Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello,
I have the following table loaded in Power Query which is updated regularly with changing number of columns in the source Excel spreadsheet. I am trying to find a dynamic way to replace all values in the entire table where it is 0 to null. Is this possible?
Currently, this is the step used but it is not dynamic when the columns change:
= Table.ReplaceValue(Source,"0",null,Replacer.ReplaceValue,{"Week number", "Stock", "Sold", "Returns"})
Week number | Stock | Sold | Returns |
1 | 121 | 89 | 32 |
2 | 212 | 200 | 12 |
3 | 142 | 0 | 0 |
4 | 846 | 845 | 1 |
5 | 0 | 500 | 52 |
6 | 231 | 0 | 200 |
7 | 514 | 51 | 0 |
8 | 874 | 551 | 323 |
9 | 0 | 84 | 464 |
10 | 152 | 54 | 0 |
11 | 560 | 0 | 360 |
12 | 614 | 614 | 0 |
Solved! Go to Solution.
You can replace
{"Week number", "Stock", "Sold", "Returns"}
with
Table.ColumnNames(Source)
You can replace
{"Week number", "Stock", "Sold", "Returns"}
with
Table.ColumnNames(Source)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.