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 the following fields: Product_ID, Orders_to_date, and Date. Orders_to_date has the cummulative total of orders the product has acummulated until that date. Now I need a DAX code that substracts Orders_to_date(t-1) from Orders_to_date(t) for each product and date in the source table. Hope the pic bellow helps to explains it better.

Thanks all for your help

6 Replies

    • 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

      Anonymous 

       

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

      Best
      D