Forum Discussion
PQ How to replace 1 to 0 ?
Hi All
Hi Anonymous ,
The operation in Power Query will be used for the entire column. Currently it's not support the change the value of single row.
You may submit this as an idea.
https://ideas.powerbi.com/ideas/
Best Regards,
Jay
negi007
Community Champion
Community ChampionAnonymous When you change value in powerquery window, it will replace all values. So there is no direct way to change one cell value and replace with other. Using a condition, you can force only a certain value to be replaced based on fullfilling the criteria.
You can refer to below link as well for more details
https://stackoverflow.com/questions/59827153/change-value-of-a-single-cell-in-power-bi