Forum Discussion

anwargabr's avatar
anwargabr
Helper I
3 years ago
Solved

DATE DIFF Measure

Dear Experts,

 

I need help to write DAX measure or variables calculating the DATE differnce as follows:

if "FROM" not qual to "ISSUE DATE", 

calculate the DAT FIFF in column "FROM" at any date with the previous date "Dates"

 

th eresult shoul be

  • all "form" 30/3 should be ignored as from = issue
  • DATES “1/10, 25/11, 26/11 and 28/11" diff will be ZERO
  • DATES 30/9 and 27/11 will be difference.

Thanks,

 

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi anwargabr ,

    Please try to change the measure.

    Measure = var _1=CALCULATE(MAX('Table'[From]),FILTER(ALL('Table'),'Table'[Index]=SELECTEDVALUE('Table'[Index])-1))

return 
IF(MAX('Table'[From])=SELECTEDVALUE('Table'[issue date]),BLANK(),DATEDIFF(_1,MAX('Table'[From]),DAY))

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi anwargabr ,

    I have created a simple sample, please refer to my pbix file to see if it helps you.

    Create a measure.

    Measure = var _1=CALCULATE(MAX('Table'[dates]),FILTER(ALL('Table'),'Table'[Index]=SELECTEDVALUE('Table'[Index])-1))

return 
IF(MAX('Table'[From])=SELECTEDVALUE('Table'[issue date]),BLANK(),DATEDIFF(_1,MAX('Table'[From]),DAY))

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • anwargabr's avatar
    anwargabr
    Helper I
    3 years ago

    Dear Polly,

     

    Thanks for your help, actually the calculation is wrong as the results should be

    I've attached the excel file for my saple data

     

    test DATE DIFF.xlsx

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi anwargabr ,

      Please try to change the measure.

      Measure = var _1=CALCULATE(MAX('Table'[From]),FILTER(ALL('Table'),'Table'[Index]=SELECTEDVALUE('Table'[Index])-1))

return 
IF(MAX('Table'[From])=SELECTEDVALUE('Table'[issue date]),BLANK(),DATEDIFF(_1,MAX('Table'[From]),DAY))

      If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

       

      Best Regards
      Community Support Team _ Polly

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.