Forum Discussion
syhchan
4 years agoNew Member
Need help in computing delta between 2 snapshots
Hi all,
I have a table 'PO Calculations' containing purchase order quantity snapshots identified by "Run Date Key". I want to compute the "Delta" between the current snapshot with a baseline snapshot for each PO Key. I created a DAX like below with a baseline Run Date 2022-05-04:
Delta:=
SUMX(
VALUES('PO Calculations'[PO_Key]),
[PO Open Quantity] -
CALCULATE(
[PO Open Quantity],
FILTER( ALL('Run Date'[Run Date Key]),
'Run Date'[Run Date Key] = DATE(2022, 05, 04)
),
'PO Calculations'[PO_Key] = EARLIER('PO Calculations'[PO_Key])
)
)
However, the "Delta" is computed only for 2022-05-04 and not other Run Date Key:
I would expect all the Delta should be 0, but it works only for Snapshot on 2022-05-04.
Any help is appreciated.
Best Regards,
Molly
1 Reply
- amitchandak
Super User
syhchan , You should be able to use DOD or Date vs last noncontinuous Date comparison
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9