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:

     

     

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: