I'm trying to add leading zeros into a column in power query call JobCodes. I know I can do this by adding a new column using Text.Start([JobCodes],5,"0")
, but I don't want to add a new column and go back to remove the column I don't need. I want to be able to do this in one step using Table.TransformColumns
function. Is this possible?
Code:
Table.TransformColumns(#"Changed Type", each Text.PadStart([JobCodes],5,"0"))
Error:
Expression.Error: We cannot convert a value of type Function to type List. Details: Value=Function Type=Type