Forum Discussion
Ranking values comparing two weeks
Seems is not working anyway johnt75
Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure
Could you please rewrite formulas as you expected? Thanks
Perfect johnt75 , i'll try. Which is the measure expression for calculating PdL for the current week?
Because actually this is the result:
With the following measures:
PdLCurrentWeek = CALCULATE([PdL],DATEADD('Date'[Date],7,DAY))
PdLLastWeek = CALCULATE([PdL],DATEADD('Date'[Date],-7,DAY))
RankCurrentWeek = RANKX('Date',[PdLCurrentWeek])
RankLastWeek = RANKX('Date',[PdLLastWeek])
RankDifference = [RankCurrentWeek]-[RankLastWeek]
Thanks
which measure is in the Wn column on that visual? that's the one you should use for as the base measure for calculating PdL for current week.
also, I think the RANKX functions need the data table as a parameter, not the Date table
You need the RANKX functions to work over the UT table, not the Date table
Seems is not working anyway johnt75
Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure
Could you please rewrite formulas as you expected? Thanks