Forum Discussion

AfnanAbuArida's avatar
AfnanAbuArida
Frequent Visitor
2 years ago
Solved

Replace Number with Text on Power Query

Hello

 

I have a column named "Last Dividend Per Share" and I want to replace all the value of 0 with Not Available. How can I do that? 

 

 

Best, 

Need Help
  • foodd's avatar
    foodd
    2 years ago

    = Table.ReplaceValue(#"Previous Step","0","Not Available",Replacer.ReplaceValue,{"Last Dividend Per Share"})

     

    Or through the GUI:

     

     

1 Reply

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    = Table.ReplaceValue(#"Previous Step","0","Not Available",Replacer.ReplaceValue,{"Last Dividend Per Share"})

     

    Or through the GUI: