How to split HH:MM:SS in 3 columns

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: