cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Paulyeo11
Impactful Individual
Impactful Individual

PQ How to replace 1 to 0 ?

Hi All

Paulyeo11_0-1607768471331.png

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

7 REPLIES 7
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

negi007
Super User
Super User

@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

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


mahoneypat
Super User
Super User

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Paulyeo11
Impactful Individual
Impactful Individual

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
Super User
Super User

@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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Fowmy
Super User
Super User

@Paulyeo11 

Right Click on the column, choose to Replace Value

 

Fowmy_0-1607769455662.png

________________________

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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Paulyeo11
Impactful Individual
Impactful Individual

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

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors