Solved: Decimal to time

goraem · ‎11-30-2021

Hi, I have a column with time in decimal i.e 83.86, how do i convert this to hh:mm?

Thanks

mahoneypat · ‎11-30-2021

Please see this article. Keep your column as a decimal, and format it at the end.

Calculate and Format Durations in DAX – Hoosier BI

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

View solution in original post

CNENFRNL · ‎12-01-2021

Easy job in Excel

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!