Snippets Collections
Sales Rep Rank =

RANKX(
	ALL( Sales[Sales Rep]),
	[Total Sales],
	Dense
)

//Dense = not skip
Best Selling Day/Date =

CONCATENATEX(
	TOPN(
		1,
		'Calendar',
		[Total Sales]
		),
	FORMAT( 'Calendar'[Date], "dd-mmm" )
	)
Top Selling Product =

TOPN(
	1,
	VALUES( Sales[ProductID] ),
	[Total Sales]
)
Best Selling Day/Date =

TOPN(
	1,
	'Calendar',
	[Total Sales]
)
Week Rank = 

RANKX(
    ALL( 'Calendar' ),
    'Calendar'[Week StartDate], , ASC, Dense)
star

Tue Dec 26 2023 07:58:24 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.ranks #dax.all #ranking
star

Mon Dec 25 2023 14:05:21 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.topn #ranking #dax.format #dax.concatenatex
star

Mon Dec 25 2023 13:57:48 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.topn #ranking #dax.values
star

Mon Dec 25 2023 13:55:40 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.topn #ranking

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension