Forum Discussion

Poloscopie's avatar
Poloscopie
Frequent Visitor
1 year ago
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...
  • lbendlin's avatar
    lbendlin
    1 year ago

    I missed the wrong PREVIOUSDAY reference

     

     

Poloscopie's avatar
Poloscopie
Frequent Visitor
1 year ago

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.

lbendlin's avatar
lbendlin
Super User
1 year ago

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