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?
Go to Solution.
you could use the below Dax code for creating the column :
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.
View solution in original post
Thanks @MahyarTF for this
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.