PQ How to replace 1 to 0 ?

[Paulyeo11]

Hi All

[v-jayw-msft · Accepted solution]

Hi @Paulyeo11 ,

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]

@Paulyeo11 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

[mahoneypat]

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

 = [User] = "abc@xyz.com" then 0 else [IsManager]

Regards,

Pat

[Paulyeo11]

Hi Mahoney

Thank you for sharing. 

I don't understand why i need to create condition , since i only need to edit the table data. 

Paul

[Fowmy]

@Paulyeo11 

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

[Fowmy]

@Paulyeo11 

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

[Paulyeo11]

Hi Fowmy

Thank you very much for sharing, But it will replace that column every row. what i need is just only edit that column at certain row. 

Paul