Forum Discussion
Cyriackpazhe
Helper III
Helper IIIRankX
Why is this happening. I want to rank the each quarter in the respective years. How come this is happening. Any explanation as to why this is happening when it should give the correct results. ...
divyed
Super User
Super UserHello Cyriackpazhe ,
You can try below dax for your purpose, this will be easier and optimized :
NewRank =
ROWNUMBER (
ALL ( Datestbl[Year], Datestbl[QuarterOfYear] ), // Add fields you want in visual
ORDERBY ( [TotalSales], DESC ),
PARTITIONBY ( Datestbl[Year] ) //Will reset ranking for each year
)
I hope this helps.
Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.
Warm Regards,
Neeraj