Calulcate Total Time difference between two datetimes

[Arranafc19]

Hi ,

I am working on a measure which calculates the total time difference between datetime columns in power bi.

I am using the below custom column to get this but my issue is that this creates a text type column which will not allow me to sum.

=Duration.ToText([AlarmClearedUTC]-[AlarmSentUTC])

Is there a way to get the time difference between datetimes which will then allow me to sum this up in a measure ?

[Anonymous · Accepted solution]

Hi  @Arranafc19 ,

You can use "datediff" function for calculation.

Here is the reference:

https://dax.guide/datediff/

Best Regards,
Kelly

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

[harshnathani]

Hi @Arranafc19 ,

You can try these solutions

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

https://community.powerbi.com/t5/Desktop/Calculate-Hours-between-dates-for-only-business-hours/td-p/...

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

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