Convert seconds to hh:mm:ss in DAX

pbi
Author

Paulius Alaburda

Published

June 23, 2024

Solutions to convert an integer into a time format in DAX are not great. The default should be FORMAT([seconds], "hh:mm:ss") but it doesn’t work on a hierachical two-way matrix. Here’s my preffered way:

https://stackoverflow.com/questions/45584262/how-to-convert-seconds-into-hhmm-format-in-power-bi

Measure =
  VAR _hours_fraction = seconds/3600
  VAR _hours = TRUNC(_hours_fraction)
  VAR _minutes_fraction = (_hours_fraction - _hours)*60
  VAR _minutes = TRUNC(_minutes_fraction)
  VAR _seconds = ROUND((_minutes_fraction - _minutes)*60, 0)

  RETURN(TIME(_hours, _minutes, _seconds))