Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have created a column in BI which represents the time, however I need to use it in a declimal format.
Due to this, is there a formula where it would say
"If the number after the decimal is 60+, add 1 to the number before the decimal point"
This would then be perfect for a time reading format.
Hope that makes sense.
Thanks
Can you post a few examples of the input and expected output?
Thank you for the reply.
Yes sure, see attached.
In the 'Hold in Mins' column, I have it saved as a decimal format and in the second pic, it comes up with 1.89 minutes when of course it should say 2 mins 29 secs.
Cheers
Take a look at this article and see if it gets you where you need to be:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
@TheLegendTamer change to Average to Sum, Now its Average to Average time will decrease, so use SUM value
Regards,
Chetan K
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |