Forum Discussion
Issue with quantity difference between two dates when sorting by date descending
I missed the wrong PREVIOUSDAY reference
Your data model is missing a calendar table - those are mandatory if you want to use time intelligence functions.
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/1447523Hello 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.
