Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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,
Solved! Go to 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:
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 12 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |