Cumulative values with start and end date

[Syndicate_Admin]

Hello

I would like to achieve the following.

Have two date targeting filters such as these:

Select year and a final date, and that I will get the accumulated amount for each month of the current year selected.

If I select year 2018 and end date 31/03/2018, it should come out:

January 2018: xxxx (where xxxx is accumulated from 1/1/2016 to 31/01/2018)

February 2018: xxxx (where xxxx is accumulated from 1/1/2016 to 31/02/2018)

March 2018: xxxx (where xxxx is accumulated from 1/1/2016 to 31/03/2018)

Thank you.

[v-yalanwu-msft · Accepted solution]

Hi, @Syndicate_Admin ;

You could create a measure as follow:

Measure = 
CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),[Date]<=MAX('Table'[Date])))

The final show:

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

[Syndicate_Admin]

Hello

The measure you say I already have but it does not do what I want, it simply makes me the total until the maximum date selected but does not give me results per month.

[amitchandak]

@Syndicate_Admin ,

Cumm Sales =
Var _max =max('Date'[date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <= _max))

or

Cumm Sales =
Var _max =max('Date'[date])

Var _max1 =maxX(allselected('Date') , 'Date'[date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <= _max && 'Date'[date] <= _max1   ))