Using RankX on a variable table

[Anonymous]

Hi

I'm trying to rank the dates for each ProdId Using RankX, but i'm not sure how to do this, when the table is a variable...

Normally you would just specify the subcategory in the 1.st input of RankX, But it seems you can't specify colulmns of variable table..


NB. This needs to be done in one big DAX function

[v-xuding-msft]

Hi @Anonymous ,

I create a calculated column based on the variable table you can have a try.

Final table =
var c = SELECTCOLUMNS(FILTER('Calendar',WEEKDAY('Calendar'[Date],2)<=5),"Date",'Calendar'[Date])
var MT = GENERATE(Table1,FILTER(c,[Date] <= Table1[Enddate]))
return
MT

Date Rank = RANKX(FILTER('Final table','Final table'[Prodid] = EARLIER('Final table'[Prodid])),'Final table'[Date],,DESC,Dense)

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.