Date Value that Refers to all Previous Dates in Chart

[Greig_Dunbar]

Hello, hoping someone can help. 

I am looking to create a function that allows the month value displayed on a table to actually refer to all data on or before the month displayed. This is in order to simulate point in time compliance figures. 

For example, May 2021 would actually show all data from the end of May 2021 backwards. January 2021 would similarly show from the end of January 2021 backwards.

Hope this helps explain my issues 🙂

Thanks

[amitchandak]

@Greig_Dunbar , are you looking for cumulative?

example

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

Cumm Sales till month back= CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=eomonth(max(date[Date]),-1) ))