Cumulative % calculation

Super User

4 years ago

saukulkarni22 , You can use Week Number of week Rank, better it come from a separate date/week table

example measure

CALCULATE(AverageX(Values(Date[Week Rank] ), [Your Mesure]), FILTER(ALL('Date'), 'Date'[Week Rank]<=max('Date'[Week Rank])))

CALCULATE(AverageX(Values(Date[Week number] ), [Your Mesure]), FILTER(ALL('Date'), 'Date'[Week number]<=max('Date'[Week number])))

You can use allselected in place of all

CALCULATE(AverageX(Values(Date[Week Rank] ), [Your Mesure]), FILTER(ALLselected('Date'), 'Date'[Week Rank]<=max('Date'[Week Rank])))

CALCULATE(AverageX(Values(Date[Week number] ), [Your Mesure]), FILTER(ALLselected('Date'), 'Date'[Week number]<=max('Date'[Week number])))

Week rank column

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

Forum Discussion