DAX function HH:MM:SS to Decimal Format

[MarcioL]

Hi all!

I have this the folllowing time format in DAX (I do not have access to this column in Power BI Editor Query as I buit it in DAX).

I need a DAX function to add a column with this time in decimal format so I can use in a chart. I do not need AM and PM info as I have it in other column.

Much appreciated if you can assist.

[edhans · Accepted solution]

Use the FORMAT function to change data types. See this for the various formats you can use.

= FORMAT(Table1[Test],"General Number")

Note it will take AM/PM into account. So 3:32pm would be 0.647222 and 3:32am would be .147222

[vissvess]

The input was useful.

The solution worked. But the generated column is in the format of text and not able to convert it to decimal number. 

I need to aggregate(Sum/average) which is not possible with text format.

Anyone please help me with this.

Thanks