Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |