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
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.