Forum Discussion

Jorr13's avatar
Jorr13
Frequent Visitor
4 years ago
Solved

How would I replace individual zeros in Power Query Editor but not if a number included a zero

How would I replace individual zeros with blanks but leave zeros if it was contained within say a phone number?   Want to replace 0 with nothing/blank but when I use the repalce values function in ...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    Jorr13,

     

    Try this Power Query step:

     

    ReplaceText = Table.ReplaceValue(
    Source,
    each if [Column1] = "0" then null else "0",
    each if [Column1] = "0" then [Column1] else "",
    Replacer.ReplaceText,
    {"Column1"}
  )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Jorr13 , 

Please refer to my pbix file to see if it helps you.

= Table.ReplaceValue(Source,"0","",Replacer.ReplaceValue,{"Column1"})

If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.