Forum Discussion

Juarenga's avatar
Juarenga
New Member
6 years ago

DAX code - Disaggregates cummulative values

Hello all, I'm having trouble figuring out the right DAX coding here. I want to calculate a column that disaggregates the cummulative values which are the known values. For instance, my table has ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Juarenga's avatar
Juarenga
New Member
6 years ago

Thanks for your reply. I tryed to replacate your formula but all I get is the same content of "Orders_to_Date" column, see:

Please advise. Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    i have a similar issue, did you fix it?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Even though it's doable in DAX, you should do it in Power Query. This is where such calculations belong and are easy.

      Best
      D
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        yeah,  i went back to power query and add a column with the date -1 day, after that i create another column with the data of that day and the column for the difference