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

View all the Fabric Data Days sessions on demand. View schedule

Reply
Jo5hua22
Helper I
Helper I

Cumulative calculation of total rows in a month and dividing by current month

Hi all,

I am trying to do a calculation wherein I have to perform cumulative calculation of total values (rows) in a month, followed by next month and then dividing the value with the current month

 

For example, there are 5 rows in January 2021, 3 rows in February 2021, 2 rows in March 2021. Then I need to add the 3 months and show in the visual of the fourth month with the value of (5+3+2)/ 4 (which is the 4th month in the year)

 

Can someone please help me out?

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data in usable format (not as a picture) and show the expected outcome.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors