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,
1 ACCEPTED SOLUTION
= Table.ReplaceValue(#"Previous Step","0","Not Available",Replacer.ReplaceValue,{"Last Dividend Per Share"})
Or through the GUI:
= Table.ReplaceValue(#"Previous Step","0","Not Available",Replacer.ReplaceValue,{"Last Dividend Per Share"})
Or through the GUI:
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
