Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to rank sales quarter as per below. My data set has product column but I only want to rank sales quarter.
Ideal output:
Sales Quarter | Product | Rank |
22-Q4 | A | 1 |
22-Q4 | B | 1 |
23-Q1 | C | 2 |
23-Q1 | D | 2 |
When I apply below DAX: RANKX('Calendar',Calendar[Sale Quarter],,ASC )
Power BI rank all the row as per below table.
Sales Quarter | Product | Rank |
22-Q4 | A | 1 |
22-Q4 | B | 1 |
23-Q1 | C | 3 |
23-Q1 | D | 3 |
Is it possible to rank value based on sales quarter only? or I must create separate calendar table? Thanks for your help!
Solved! Go to Solution.
@irenelitw629 , Try with dense option
RANKX('Calendar',Calendar[Sale Quarter],,ASC,dense )
@irenelitw629 , Try with dense option
RANKX('Calendar',Calendar[Sale Quarter],,ASC,dense )