Forum Discussion
Issue with quantity difference between two dates when sorting by date descending
I missed the wrong PREVIOUSDAY reference
Hello Ibendlin, thanks for your answer.
Unfortunately, having a calendar table doesn't seem to help me here, I actually tried and doesn't see any solution with it.
The only table on this job is this one:
Even worse, if I try to create a "descending sorting column" in my calendar table, the action of sorting the Date column by this new column is impossible as it creates a circular dependency.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hello Ibdendlin,
You'll find the report right here.
The expected result would be as below in term of calculation: the delta D-1 is what is the difference between D0 and D-1 data (based on the snapshot date in column), but the sorting of the column values should be from the most recent to the oldest => first column displays 2024-12-02 data, second column 2024-12-01, etc.
see attached.
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).