Forum Discussion
Column format change not applying
Hi all,
So I am getting time duration from a sharepoint list in fractions of days, and when loading into power bi using power query I can transform it to "duration" but then this change doesn't apply when working with the data:
Power query:
But when applying the changes:
Data type is still decimal:
I know I can extract the data I want as text, but don't understand why this is happening.
Thanks in advance 🙂
Hi Victormar ,
I'm afraid you'll have to convert it to text since, as far as I know, Power BI doesn't yet handle fractions of a second in time format.
The decimal representation you have is in days. Taking that into account, you can convert it to the format you show (text) in a calculated column:
NewColumn = TRUNC(Table4[Zeit2 - Copy]) & "." & //Days FORMAT(TRUNC(Table4[Zeit2 - Copy]*24);"00") & ":" &//Hours FORMAT(TRUNC(Table4[Zeit2 - Copy]*24*60);"00") & ":" & //Minutes FORMAT(Table4[Zeit2 - Copy]*24*60*60;"00.0000000") //SecondsBest Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Victormar , In Dax you have Time, not duration. Can you manually Change it text and check
Hi Victormar ,
I'm afraid you'll have to convert it to text since, as far as I know, Power BI doesn't yet handle fractions of a second in time format.
The decimal representation you have is in days. Taking that into account, you can convert it to the format you show (text) in a calculated column:
NewColumn = TRUNC(Table4[Zeit2 - Copy]) & "." & //Days FORMAT(TRUNC(Table4[Zeit2 - Copy]*24);"00") & ":" &//Hours FORMAT(TRUNC(Table4[Zeit2 - Copy]*24*60);"00") & ":" & //Minutes FORMAT(Table4[Zeit2 - Copy]*24*60*60;"00.0000000") //SecondsBest Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks to both, and sorry for the late reply. They changed my pc and was setting everything up.
Many thanks!
