Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate difference between 2 dates and show a certain result

Hi all,   I am completely new to Power BI and I need your help.   I am trying to write a DAX measure to calculate the difference between 2 dates and display a certain result. There are 3 importan...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • dk_dk's avatar
    dk_dk
    2 years ago

    Hi Anonymous 

    Could you try some troubleshooting steps:

    Delete the Switch statement below RETURN, and instead try returning some of the variables, starting with "scenario", and see at what point is the measure broken. Check for the variables called DelOnTime, DelLate, DelEarly, etc..., if you get the expected result.

    Try to make calculated column instead of measure and see if that works.

    If you can provide a snapshot of your source data, that would help me in understanding the possible cause as well.




dk_dk's avatar
dk_dk
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 

Could you try some troubleshooting steps:

Delete the Switch statement below RETURN, and instead try returning some of the variables, starting with "scenario", and see at what point is the measure broken. Check for the variables called DelOnTime, DelLate, DelEarly, etc..., if you get the expected result.

Try to make calculated column instead of measure and see if that works.

If you can provide a snapshot of your source data, that would help me in understanding the possible cause as well.




Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dk_dk,

 

Thanks again for your suggestions and for supporting me with this issue. I tried the other alternative you suggested and I can confirm that the measure works perfectly now.

Thanks again.