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.   ...
Need Help
  • amitchandak's avatar
    amitchandak
    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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