Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
it sound simple but it is giving me error. I have one column with minutes and I want to convert it in Hours (hh:mm)
What I am doing wrong=
I have / I want:
123123 / hh:mm
1232/ hh:mm
2445/ hh:mm
22/ hh:mm
4455/ hh:mm
What am I doing wrong?
Thx so much,
JFB
Solved! Go to Solution.
He seems to complain simply because he's using ";" instead of "," as a separator
The rest should be fine, even if you keep in mind that it will flip if the result is longer than 24 hours
Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.
Contact me privately for assistance with any large-scale BI needs, tutoring, etc.
Bless you
@Anonymous , Try like
time(Quotient([duration_agent_status],24),Quotient(mod([duration_agent_status],24),60))
also check these
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
@Anonymous , Try like
time(Quotient([duration_agent_status],24),Quotient(mod([duration_agent_status],24),60))
also check these
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
He seems to complain simply because he's using ";" instead of "," as a separator
The rest should be fine, even if you keep in mind that it will flip if the result is longer than 24 hours
Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.
Contact me privately for assistance with any large-scale BI needs, tutoring, etc.
Bless you
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |