Forum Discussion

h4n1234's avatar
h4n1234
Frequent Visitor
4 years ago
Solved

DAX help with circular referencing

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!

 

 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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