Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • edhans's avatar
    edhans
    7 years ago

    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

edhans's avatar
edhans
Community Champion
7 years ago

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's avatar
    vissvess
    Helper V
    6 years ago

    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