Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |