Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
PREVIOUSDAY is a time-intel function and works correctly only on proper Date tables, not on any arbitrary tables.
Best
D
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.
i have a similar issue, did you fix it?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |