Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I have 13:25:55 and I need just one column with the seconds, 55.
I've already tried slipt column by delimiter : , but didn't work.
Solved! Go to Solution.
@Anonymous A cleaner way might be to use the HOUR, MINUTE, and SECOND functions to extract the values.
-Parker
Hello @Anonymous,
You can use the HOUR, MINUTE and SECOND functions like this:
Create 3 new columns with the following DAX:
Hours = HOUR('Table1'[TimeColumn])
Minutes = MINUTE('Table1'[TimeColumn])
Seconds = SECOND('Table1'[TimeColumn])
Here's the result:
Hello @Anonymous,
You can use the HOUR, MINUTE and SECOND functions like this:
Create 3 new columns with the following DAX:
Hours = HOUR('Table1'[TimeColumn])
Minutes = MINUTE('Table1'[TimeColumn])
Seconds = SECOND('Table1'[TimeColumn])
Here's the result:
@Anonymous A cleaner way might be to use the HOUR, MINUTE, and SECOND functions to extract the values.
-Parker
Make sure you use some of teh advanced options when you're using the split column by delimiter function. You want a Right split, and only the first delimiter.