cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hugus Regular Visitor
Regular Visitor

cumulative sum by category over month

Hi

I want to get a column that calculates the month to date sum of a value by site (category).

basically i have rows of data - each row represents the tonnes produced per site per day. I need a column that gives me a cumulative sum of tonnes produced month to date per site.....

 

thanks!

 

sum cumulative.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: cumulative sum by category over month

Hi @hugus 

Create a calendar table

calendar = CALENDARAUTO()
Create relationship betwenn "calendar"table and your data table
 
Create measures in your data table
Measure = TOTALMTD(SUM(Sheet6[value per day]),'calendar'[Date])
5.png
Best Regards
Maggie
 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 REPLY 1
Community Support Team
Community Support Team

Re: cumulative sum by category over month

Hi @hugus 

Create a calendar table

calendar = CALENDARAUTO()
Create relationship betwenn "calendar"table and your data table
 
Create measures in your data table
Measure = TOTALMTD(SUM(Sheet6[value per day]),'calendar'[Date])
5.png
Best Regards
Maggie
 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.