Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm new to Power BI and DAX and I haven't been able to find a solution to my problem.
I have a table organized with Job #, Month, Data. I would like to be able to add a column to rank the data within each month. Then when selecting a specific month in my visuals I can see the ranking for the data for that month.
Table name is '2018 YTD'.
So far I haven't been able to use the FILTER function to get a usable result. I can get the rank of all the data in the REVENUE column, but I can't get it broken down by month so that each month has a ranking of 1 through 10.
Rank Revenue by Month = if(rank.eq('2018 YTD'[Revenue],'2018 YTD'[revenue],DESC)<11,rank.eq('2018 YTD'[Revenue],'2018 YTD'[Revenue],DESC),0)
Thank you for your help!
Solved! Go to Solution.
HI @adelimont
Try this column
Rank Revenue by Month = RANKX ( FILTER ( 'YTD', 'YTD'[Month] = EARLIER ( 'YTD'[Month] ) ), 'YTD'[Revenue], , DESC, DENSE )
Hi @adelimont
This calculated column will be pretty close. Let me know if you would like this as a calculated measure
Rank Revenue as Column = RANKX( FILTER( '2018 YTD', '2018 YTD'[Month] = EARLIER('2018 YTD'[Month])), '2018 YTD'[Revenue] )
HI @adelimont
Try this column
Rank Revenue by Month = RANKX ( FILTER ( 'YTD', 'YTD'[Month] = EARLIER ( 'YTD'[Month] ) ), 'YTD'[Revenue], , DESC, DENSE )
Thank you @Zubair_Muhammad and @Phil_Seamark so much for the quick responses! This seems to be working!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |