topic Re: DAX code - Disaggregates cummulative values in DAX Commands and Tips

DAX code - Disaggregates cummulative values

Juarenga — Wed, 04 Sep 2019 03:57:44 GMT

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

Re: DAX code - Disaggregates cummulative values

Anonymous — Wed, 04 Sep 2019 04:38:47 GMT

Re: DAX code - Disaggregates cummulative values

Juarenga — Sun, 08 Sep 2019 17:00:43 GMT

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.

Re: DAX code - Disaggregates cummulative values

Anonymous — Sat, 11 Apr 2020 16:05:42 GMT

i have a similar issue, did you fix it?

Re: DAX code - Disaggregates cummulative values

Anonymous — Sat, 11 Apr 2020 23:37:19 GMT

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

Re: DAX code - Disaggregates cummulative values

Anonymous — Sat, 11 Apr 2020 23:39:57 GMT

Anonymous

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

Best
D

Re: DAX code - Disaggregates cummulative values

Anonymous — Mon, 13 Apr 2020 19:50:36 GMT

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