Forum Discussion

Jeyeline's avatar
Jeyeline
Icon for Helper III rankHelper III
1 year ago
Solved

How to calculate the difference between two dates with timeframes in a particular format

Hello All,    I have to calculate the mean time to respond based on two fields, by calculating the difference between these fields Reporting Date&Time: 18-01-2025 12:30:00 PM Actual Date&Time: 19...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • speedramps's avatar
    speedramps
    1 year ago

    Try this DAX measure ...

     

    Duration = 
DATEDIFF(
    SELECTEDVALUE(yourdata[Reporting Date&Time]),
    SELECTEDVALUE(yourdata[Actual Date&Time]),
    MINUTE
)

      

    Please click the [accept solution] and thumbs up button. Thank you

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Hi Jeyeline ,

Assuming that your table model look like this:

 

You can achieve the desired result creating a new measure with this DAX:

Mean2 Time to Respond (Minutes) = 
DATEDIFF(SELECTEDVALUE('Table'[Reporting Date&Time]), SELECTEDVALUE('Table'[Actual Date&Time]), MINUTE)

Your result in the matrix will look like this:

If you want as calculated column, you can use this DAX:

Mean Time to Respond (Minutes) = 
DATEDIFF('Table'[Reporting Date&Time], 'Table'[Actual Date&Time], MINUTE)

And your result will look like this: