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

[Jeyeline]

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-01-2025 9:00:00 AM

However while using the difference functions i am not receiving the expected results.

Expectation is, calculating the difference in minutes. How that could be possible in DAX. Can anyone help on this

[Bibiano_Geraldo]

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:

[anmolmalviya05]

Hi , Hope you are doing good.

Please try the below measure:

MeanTimeToRespond =
DATEDIFF(
'TableName'[Reporting Date&Time],
'TableName'[Actual Date&Time],
MINUTE
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

@Jeyeline

[DivkLearner]

Hello @Jeyeline 

we can use the following formula

DifferenceDate = DATEDIFF(Reporting Date&Time:,Actual Date&Time,MINUTE)

Please refer: https://learn.microsoft.com/en-us/dax/datediff-function-dax

Best regards,
DivKlearner – A Bit Forward Daily
Join us as we explore and learn IT together.
Discover simplified IT learning on YouTube

[speedramps · Accepted solution]

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