hola necesito mostrar tiempo en 25 horas pero muestra 1 dia y 1 hora
Go to Solution.
@daniel_1986 , refer https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
View solution in original post
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.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.