Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |