cancel
Showing results for
Did you mean:
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

## Re: Cumulative sum for specific time period

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.
Community Support Team

## Re: Cumulative sum for specific time period

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.

Announcements

#### 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

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

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)