Forum Discussion
Solved
Issue with quantity difference between two dates when sorting by date descending
Hello dear PBI community, I have an issue with a metric on a report, which calculates the difference of a quantity between two snapshots. This issue occurs when I change the way the snapshots are...
I missed the wrong PREVIOUSDAY reference
Hello Ibdendlin,
Unfortunately, the formula remains broken with the sorting by date descending.
We can see that the Qty Δ D-1 isn't showing the difference between D0 quantity and D-1 quantity.
As displayed in my previous screenshot, for category A, the delta should be -400 on 12/02, -200 on 12/01, etc. The values should be like in my message 7 (or the very first screenshot on the message 1).
I missed the wrong PREVIOUSDAY reference
And it's working 🙂
I think I get the logic, thanks a lot for your help on this topic lbendlin!