Forum Discussion
kucluk_ok
3 years agoFrequent Visitor
Change data duration to seconds from format d h m s
I Have raw data duration , where the format is not standard like this i want to convert from Column "Down" to column "inSEC" using this query to manage the d=86400 seconds, h=3600seconds , m =...
- 3 years ago
inSec = SUMX ( ADDCOLUMNS ( DATATABLE ( "n", STRING, "f", INTEGER, { { "d", 86400 }, { "h", 3600 }, { "m", 60 }, { "s", 1 } } ), "@sec", VAR _p = SUBSTITUTE ( SUBSTITUTE ( SUBSTITUTE ( MID ( 'Report'[Down], 1, FIND ( [n], 'Report'[Down],, 1 ) - 1 ), "m", "|" ), "h", "|" ), "d", "|" ) RETURN VALUE ( 0 & PATHITEM ( _p, PATHLENGTH ( _p ) ) ) * [f] ), [@sec] )