Greg_Deckler
8 years agoCommunity Champion
Milliseconds Duration
Based on the original blog post around Duration from 1/25/16 by konstantinos and later blogged about here:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
...
davorgom
8 years agoFrequent Visitor
Hi Greg_Deckler
I really apreciatte your time and your help. You had sent me a little code but I don`t know how and where can I put this on te app. Can u say me how to do it?
Thanks.
- Greg_Deckler8 years agoCommunity Champion
You can use this formula in a calculated column or in a measure. The only thing that really should need to change is this line:
VAR Duration = SUM(Milliseconds[Milliseconds])
My table is called Milliseconds and my column is called Milliseconds as well.
I attached the PBIX so you can download it and see how it functions.