Forum Discussion

anwargabr's avatar
anwargabr
Icon for Helper I rankHelper 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 w...
  • 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.

anwargabr's avatar
anwargabr
Icon for Helper I rankHelper 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.

    • anwargabr's avatar
      anwargabr
      Icon for Helper I rankHelper I
      3 years ago

      Thanks and much apperciated