Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Add zero to value

Hi everyone!!!! Please help me. Do you know formula to create "custom" column the same picture? Thank you so much!!!!
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    [
f = Text.Length([DATA]),
to= if f < 3 then Text.Repeat("0",3-f) & [DATA] else [DATA]
][to]

Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this

[
f = Text.Length([DATA]),
to= if f < 3 then Text.Repeat("0",3-f) & [DATA] else [DATA]
][to]

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Your solution is perfect. It helped me solve the problem. Thank you so much!!!