Forum Discussion
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...
Give this a shot
Seconds_Measure = VAR myvalue = SELECTEDVALUE ( Table1[Column] ) RETURN ( myvalue - TRUNC ( myvalue ) ) * 86400
Give this a shot
Seconds_Measure =
VAR myvalue =
SELECTEDVALUE ( Table1[Column] )
RETURN
( myvalue - TRUNC ( myvalue ) )
* 86400
Thanks Zubair_Muhammad! It did work!
Best Regards,
Diego