Decimal minutes into time format (Tabular Cube)

1
votes

I would like to change decimal minutes into HH:mm:ss (DAX, Tabular Cube).

When I use this : measure = FORMAT(TIME(0;minutes;0);"HH:mm:ss") I get hours and minutes but without seconds. Minutes are rounded.

When I use this : measure = FORMAT(TIME(0;0;minutes*60);"HH:mm:ss") I have an error that value is too big or too small.

Thanks in advance.

1
dax

1 Answers

1
votes

DAX understands decimal time in units of days, so all that you need to do is convert decimal minutes to decimal days and format:

FORMAT ( [Minutes] / 60 / 24, "HH:mm:ss" )