Forum Discussion

dianecrz's avatar
dianecrz
Frequent Visitor
3 years ago

DAX Delta Issue - Difference Between Dates Not Working When Amount is Zero for Maximum Date Selected

I am trying to accurately calculate the difference in the amount sold between the most recent date selected and the oldest one. I used a DAX formula to create my Delta, and when calculating the diff...
delta
Difference
dianecrz's avatar
dianecrz
Frequent Visitor
3 years ago

Hi Martin_D 

The solution you provided solves the delta issue when the latest date value is blank. The screenshot below shows the results of your DAX function. 

 

 

However, it is not ideal because it converts the minimum date values to negative, which works fine for the delta calculation but can be wrongly interpreted by users, since these are positive orders from July 5th. 

 

I am considering as a second option to work on the data and insert values for dates where I do not have any order data. Please let me know if there is an easier solution. 

Thank you so much!!!

Best, 

Diane

 

  • Martin_D's avatar
    Martin_D
    Solution Sage
    3 years ago

    Hi dianecrz ,

    Would you like to provide a sample file? As long as the dates in the column headers come from Table[Snapshot Date] the measures shouldn't impact the sign (_Sign factor is one in this case).
    BR
    Martin