Forum Discussion
Helper IIIHow 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-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
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
4 Replies
speedrampsSuper User
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
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:
DivkLearnerResolver I
Hello Jeyeline
we can use the following formula
DifferenceDate = DATEDIFF(Reporting Date&Time:,Actual Date&Time,MINUTE)Best regards,
DivKlearner – A Bit Forward Daily
Join us as we explore and learn IT together.
Discover simplified IT learning on YouTube- 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
