cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
imagautham
Helper II
Helper II

How to combine 3 columns into a single column with HH:MM:SS format in Power Query editor

Hello PBI Community,

 

I have 3 columns which refers to the hours, Minutes and Seconds which an employee spent.

I tried to combine the 3 columns into a single column with HH:MM:SS format. But Im not getting accurate answer.

I selected these 3 columns in power query editor and clicked Transform->Merge Columns-> used colon as delimiter.

I get the below output.

The new column 'Merged' doesnot come in proper HH:MM:SS format. This is because in hours spent I have value as 0.

It should come as 00 in merged column.

Any idea how to do this in power query editor or in DAX?

 Screenshot 2022-11-10 110309.png

1 ACCEPTED SOLUTION
MahyarTF
Memorable Member
Memorable Member

Hi,

you could use the below Dax code for creating the column :

 time(Sheet15[Hour], Sheet15[Minutes], Sheet15[Second])
MahyarTF_0-1668063639201.png

Don't forget to change the dataType to Time and set the Format as you want.

Appreciate for your Kudos and Please mark it as solution if it helps you.

Mahyartf

View solution in original post

2 REPLIES 2
imagautham
Helper II
Helper II

Thanks @MahyarTF  for this

MahyarTF
Memorable Member
Memorable Member

Hi,

you could use the below Dax code for creating the column :

 time(Sheet15[Hour], Sheet15[Minutes], Sheet15[Second])
MahyarTF_0-1668063639201.png

Don't forget to change the dataType to Time and set the Format as you want.

Appreciate for your Kudos and Please mark it as solution if it helps you.

Mahyartf

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors