Forum Discussion
Rank by Quarters solution
Dear all, I would like to ask for your help on the below. I would like to rank by months and Quarters. I could do it for the months with the below formula. There are 2 different Tables the one ...
Hi Anonymous,
Please download the demo in the attachment.
1. Create columns for [Year] and [Quarter] in the date table.
2. Create a measure.
ranks 2 = RANKX ( ALL ( 'Date'[Year], 'Date'[Quarter] ), CALCULATE ( SUM ( Table1[Amount] ) ), , , SKIP )
Best Regards,
Dale
Hi Anonymous,
Please download the demo in the attachment.
1. Create columns for [Year] and [Quarter] in the date table.
2. Create a measure.
ranks 2 = RANKX ( ALL ( 'Date'[Year], 'Date'[Quarter] ), CALCULATE ( SUM ( Table1[Amount] ) ), , , SKIP )
Best Regards,
Dale
It worked!
Thank you very much!!!