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.
I am trying to get some result like this:
quarters since flagged-> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Quarter 3'2014 | 6.3% | 6.3% | 6.3% | 6.3% | 6.3% | 6.3% | 6.3% | 6.3% |
Quarter 4'2014 | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | |
Quarter 1'2015 | 0.7% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | ||
Quarter 2'2015 | 5.7% | 7.2% | 7.7% | 8.6% | 8.6% | |||
Quarter 3'2015 | 6.6% | 10.1% | 10.4% | 11.1% | ||||
Quarter 4'2015 | 9.4% | 13.2% | 13.9% | |||||
Quarter 1'2016 | 16.5% | 21.2% | ||||||
Quarter 2'2016 | 16.8% |
I have tried using running total quick measure but wherever the "quarter since flagged" is missing, I am getting holes in my output. Please suggest a better way to achieve this.
Hi @Anonymous
Please provide your orginal data structure and the rule to achieve final output so i can work for your scenario.
Best Regards
Maggie
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |