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
Did I answer your question? Mark my post as a solution! Kudos are also appreciated! To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypa HoosierBI on YouTube
