Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to Solution.
Hi @Arranafc19 ,
You can use "datediff" function for calculation.
Here is the reference:
Hi @Arranafc19 ,
You can use "datediff" function for calculation.
Here is the reference:
Hi @Arranafc19 ,
You can try these solutions
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |