cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
juliarossberg Frequent Visitor
Frequent Visitor

How to split HH:MM:SS in 3 columns

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Anonymous
Not applicable

Re: How to split HH:MM:SS in 3 columns

@juliarossberg A cleaner way might be to use the HOUR, MINUTE, and SECOND functions to extract the values.

 

-Parker

Highlighted
Birdjo Member
Member

Re: How to split HH:MM:SS in 3 columns

Hello @juliarossberg,

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:
image.png

3 REPLIES 3
BFroc Frequent Visitor
Frequent Visitor

Re: How to split HH:MM:SS in 3 columns

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.

Anonymous
Not applicable

Re: How to split HH:MM:SS in 3 columns

@juliarossberg A cleaner way might be to use the HOUR, MINUTE, and SECOND functions to extract the values.

 

-Parker

Highlighted
Birdjo Member
Member

Re: How to split HH:MM:SS in 3 columns

Hello @juliarossberg,

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:
image.png