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

Cumulative sum for specific time period

Hi All, 
I have 'Table1' with column 'Amount', 'date' which ranges from 2015/1/1 to 2019/12/31. I another table 'DateHelper' with a column 'date' which ranges from 2019/1/1 to 2019/12/31. I also have one to many relation between 'DateHelper' and 'Table1' by 'date' column. I need to calculate cumulative sum of 'Amount' with following visualization: let's take line chart, where y-axis directs to cumulative of 'Amount' and x-axis directs to 'date' column from 'DateHelper' (to repeat: Ranges from 2019/1/1 to 2019/12/31 ). I need to show cumulative sum of 'Amount' where year < 2019 for first day of the chart and from this point continue calculation of cumulative sum.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Cumulative sum for specific time period

@giorgi_lommidd 

 

You may add the following measure.

Measure =
CALCULATE (
    SUM ( Table1[Amount] ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date] <= MAX ( DateHelper[Date] ) )
)

 

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

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Cumulative sum for specific time period

@giorgi_lommidd 

 

You may add the following measure.

Measure =
CALCULATE (
    SUM ( Table1[Amount] ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date] <= MAX ( DateHelper[Date] ) )
)

 

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

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)