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.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
365 | |
102 | |
65 | |
51 | |
49 |
User | Count |
---|---|
338 | |
119 | |
83 | |
68 | |
62 |