Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.