Forum Discussion
Add a Leading Zero if Length = 1, else do nothing
Please assist me using Power Query to create a custom column to Add a Leading Zero if Length = 1, else do nothing.
Anonymous Add a custom column:
if Text.Length([Hours]) = 1 then "0" & [Hours] else [Hours]
Greg_Deckler
Community Champion
Community ChampionAnonymous Add a custom column:
if Text.Length([Hours]) = 1 then "0" & [Hours] else [Hours]