Forum Discussion

sirros_iot's avatar
sirros_iot
Helper III
8 years ago
Solved

Convert time to seconds

Hello all! I have a column in the hour format( HH:mm: ss), and I want to show the average of this column, but, I'm connected by DirectQuery, so, no data modeling. I would like to solve this iss...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    sirros_iot

     

    Give this a shot

     

    Seconds_Measure =
VAR myvalue =
    SELECTEDVALUE ( Table1[Column] )
RETURN
    ( myvalue - TRUNC ( myvalue ) )
        * 86400
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

sirros_iot

 

Give this a shot

 

Seconds_Measure =
VAR myvalue =
    SELECTEDVALUE ( Table1[Column] )
RETURN
    ( myvalue - TRUNC ( myvalue ) )
        * 86400
Doknights's avatar
Doknights
Frequent Visitor
3 years ago

Hello, Can you explain this formula a bit more to me?

 

The "myvalue" is that part of the formula or some custom information that has to be entered?