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

    Anonymous 

     

    PREVIOUSDAY is a time-intel function and works correctly only on proper Date tables, not on any arbitrary tables.

    Best
    D