Forum Discussion

irenelitw629's avatar
irenelitw629
Helper II
3 years ago
Solved

RANX Issue

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 QuarterProductRank
22-Q4A1
22-Q4B1
23-Q1C2
23-Q1D2

 

When I apply below DAX:  RANKX('Calendar',Calendar[Sale Quarter],,ASC )

Power BI rank all the row as per below table.

Sales QuarterProductRank
22-Q4A1
22-Q4B1
23-Q1C3
23-Q1D3

 

Is it possible to rank value based on sales quarter only? or I must create separate calendar table? Thanks for your help!

1 Reply