Cumulative sum shows value beyond last month

[Dunner2020]

Hi there,

I have created a measure that calculates the cumulative sum until last month. Here is my measure:

**bleep** sum =

var CurrentDate = MAX('Outages '[Actual Interruption Start Date Time])

Var lastmonth =EOMONTH(TODAY(),-1)

Var _CYMonth = MONTH(TODAY())

Var _RYMonth = if(_CYMonth > 3 && _CYMonth <= 12, _CYMonth - 3,_CYMonth + 9)

Return

sumx(FILTER(ALL('Outages'),'Outages '[Actual Interruption Start Date Time]<=CurrentDate && 'Outages '[Actual Interruption Start Date Time ] <=lastmonth ),

[sum_measure])

The above measure produced the following output

:

The problem with the above output is that it shows the value of October and November. It should show value up to September.

The expected output would be like:

I am not sure where am I making the mistake. Any help would be really appreciated.

[Ashish_Mathur · Accepted solution]

Hi,

Assuming you have dragged Month name from the Calendar Table, this should work

=if(max(calendar[date])>today(),blank(),[your measure])

Hope this helps.

[grandtotal]

Check out this method:

https://www.sqlbi.com/blog/marco/2018/08/10/the-hidden-secrets-of-totalytd/

You should use the CALCULATE  and  DATESYTD approach.

[Dunner2020]

@grandtotal  I am not interested in calculating DateYTD. I wanted to calculate the cumulative sum by the end of last month.