Search code examples
powerquery

Remove leading zeroes in PowerQuery

Thank you in advanced for everyone's help. I am relatively a novice at power query. I tried a few formulas but none worked.

All I am trying to do is if the value in column Customer PO starts with 00 or 0, it is removed/deleted.

enter image description here

= Table.TransformColumns(#"Filtered Rows1",{{"Customer PO",each if Text.Start(Text.From(),2)="00" then""&Text.From() else _ }})

Tried this formula but it only adds in from of the value.

Solution

  • Edit: you seem to want to get rid of leading zeroes

    = Table.TransformColumns(#"PriorStepNameHere",{{"Customer PO", each Text.From(Number.From(_)), type text}})