DAX help with circular referencing

[h4n1234]

Hi

I would like to achieve the below in PBI through DAX (this is simple version of the data)

As you can see below the total cell (tota) references its previous month cumulative value.

Here is the cell reference for Jan. It does not reference a previous month

I have attempted this in multiple ways using the DAX earlier column function, or creating individual total measurements for each month but it crashed the file.

Any help is very much appreciated!

[amitchandak · Accepted solution]

@h4n1234 , You need to create a measure like this

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

refer if needed

Rolling Months Formula: https://youtu.be/GS5O4G81fww