Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
The below is the table I am working with, and I want to rank by week ending date.
I am trying to formula :
Solved! Go to Solution.
@Spudder112 , Hope you are creating a column not measure
This should work as column
Week Rank = RANKX(('Table 1'),'Table 1'[week ending date],,ASC,Dense)
Also it is always better to have a separate Date/week Table
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
@Spudder112 , Hope you are creating a column not measure
This should work as column
Week Rank = RANKX(('Table 1'),'Table 1'[week ending date],,ASC,Dense)
Also it is always better to have a separate Date/week Table
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Ah, I was using the measure feature instead of column. Thank you! Also for reminding me to make a separate date table.
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |