Hi, I've created a PowerPivot DAX measure to list my TOP 100 Brands. I would like to find a way to see for the month of May 2019 vs 2018 vs 2017. The measure below shows me each year total compared side by side.
I would like to have a slicer control the month.
TOP 100 BRANDS:=VAR RankingContext =
VALUES ( 'tblVendor 2'[NAME] )
VAR TopNumber = 100
RETURN
CALCULATE (
[SALES TOTAL NET RETAIL],
TOPN ( TopNumber, ALL( 'tblVendor 2'[NAME] ),[SALES TOTAL NET RETAIL] ),
RankingContext
)
I would like to have a slicer control the month.
TOP 100 BRANDS:=VAR RankingContext =
VALUES ( 'tblVendor 2'[NAME] )
VAR TopNumber = 100
RETURN
CALCULATE (
[SALES TOTAL NET RETAIL],
TOPN ( TopNumber, ALL( 'tblVendor 2'[NAME] ),[SALES TOTAL NET RETAIL] ),
RankingContext
)
