PQ How to replace 1 to 0 ?

Anonymous 

Right Click on the column, choose to Replace Value

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

Anonymous 

Then you need to do it in the source. In PQ, you apply logic, if that logic meets, you perform an action.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

I agree you should change it in the source.  For a short-term fix, you could add a custom column with

 = [User] = "[email protected]" then 0 else [IsManager]

Regards,

Pat

Anonymous 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