topic Re: necesito mostrar 25 horas in DAX Commands and Tips

necesito mostrar 25 horas

daniel_1986 — Mon, 10 Aug 2020 22:06:14 GMT

hola necesito mostrar tiempo en 25 horas pero muestra 1 dia y 1 hora

Re: necesito mostrar 25 horas

mahoneypat — Tue, 11 Aug 2020 00:45:34 GMT

More description with your example data and desired output would be helpful, but here is one approach. You can add a custom column in the query editor with this formula and a column called Hours.

= Text.From(Number.RoundDown([Hours]/24)) & " days " & Text.From(Number.Mod([Hours], 24)) & " hours"

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

Re: necesito mostrar 25 horas

amitchandak — Tue, 11 Aug 2020 02:29:23 GMT

daniel_1986 , refer 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