Forum Discussion
DAX function HH:MM:SS to Decimal Format
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.
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
2 Replies
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
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
