Forum Discussion

Water's avatar
Water
Icon for Helper II rankHelper II
3 years ago

DAX for difference between each date and previous date per occurrence

Hi,    Please help with DAX to accomplish the following?   For  each vehicle many jobs are performed at various date intervals.  Each time a job is performed, the date (JOB_OPEN_DATE) is captured...
date calculations
Need help with DAX
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

This is not giving you what you asked for, but probably what you wanted.

 

 

  • Water's avatar
    Water
    Icon for Helper II rankHelper II
    3 years ago

    Thank you very much for an inbetween solution! 

     

    However, idealy I still hope for an output like the below in days difference:

     

     

    Updated the Power BI file with a better date relatonships now that I understand that better. 

     

    Would you mind to please have another look?

     

    With hope and thanks, 

     

    Water