Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 with the amount and the one with the dates. But I have the dates on both tables if that helps(its connected with another table).
Solved! Go to Solution.
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!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |