DAX code - Disaggregates cummulative values

[Juarenga]

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

[Anonymous]

[Anonymous]

@Anonymous 

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

Best
D

[Juarenga]

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]

i have a similar issue, did you fix it?

[Anonymous]

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]

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