Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

How to get Mom, QoQ and YoY% calculation change

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?

YearQuarterMonthsize
2022Qtr 1March7891,78
2022Qtr 2April9623,21
2022Qtr 2May6853,63
2022Qtr 2June1528978
2022Qtr 3July195737,1
2022Qtr 3August168077,9
2022Qtr 3September294695,8
2022Qtr 4October23159,34
2022Qtr 4November214343
2022Qtr 4December42684,12
2023Qtr 1January150256,5
2023Qtr 1February167633,6
2023Qtr 1March167716,5

 

1 REPLY 1
lbendlin
Super User
Super User

Please try some of the Quick Measures that cover these patterns.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.