Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi All,
I have a question on how to calculate Mom, QoQ and YoY% change and then use it on line and clustered column chart. My data somewhat looks like this. So, for 2022 Mar to 2022 April the sales got increased from 7891 to 9623, I need that to show as MoM percentage growth and similarly for the rest.
Can anybody please help me with this?
Year | Quarter | Month | size |
2022 | Qtr 1 | March | 7891,78 |
2022 | Qtr 2 | April | 9623,21 |
2022 | Qtr 2 | May | 6853,63 |
2022 | Qtr 2 | June | 1528978 |
2022 | Qtr 3 | July | 195737,1 |
2022 | Qtr 3 | August | 168077,9 |
2022 | Qtr 3 | September | 294695,8 |
2022 | Qtr 4 | October | 23159,34 |
2022 | Qtr 4 | November | 214343 |
2022 | Qtr 4 | December | 42684,12 |
2023 | Qtr 1 | January | 150256,5 |
2023 | Qtr 1 | February | 167633,6 |
2023 | Qtr 1 | March | 167716,5 |
Please try some of the Quick Measures that cover these patterns.
User | Count |
---|---|
10 | |
9 | |
7 | |
4 | |
4 |