Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Edit values in query editor

Hi All,

 

I have 3 columns Check1,Check2 and Date. I would like to add Check3 column in query editor and would like to enter its manually as 2 and 3 for 1st and second row respectively.Is it possible to add a column and give its value manually in query editor?

 

Capture.PNG

 

Also can i edit Check2 columns value as 1,4 instead of 2,3 for 1st and 2nd row respectively.

 

Thanks in Advance.

 

6 REPLIES 6
parry2k
Super User
Super User

@Anonymous is there logic to give value for check3 column, there is many way to achieve this, like add index column or custom column and put the logic there.

 

for changing value, you can replace value function to update the values but you cannot directly edit the values.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Hi @parry2k ,

 

Thanks for your reply.

 

There is no logic for adding values in those columns. I would like to manually add those values without any logic.

 

For Changing values, How to use replace value function?

 

Thanks

@Anonymous in query editor under transform menu

 

 

image.png

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Hi @parry2k ,

 

Thanks for the reply. But if i have 2 rows and both the rows having value as 4,4 and i would like to change it to 5,6 then with the helpl of replace value function it looks like we ould not able to achieve that.

 

Thanks

@Anonymous add new column for index which will have value 1 and 2 and then add another custom column by adding index column and your old column, it will give you incremental value and in next step remove columns you don't need and rename column title. There is a way lot flexibility when it come to power query, you need to explain your problem well so that you can have exact solution to your problem



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Hi @parry2k ,

 

I just want to add one column which will have 10 rows but there is logic in those nummbers. Those all are random numbers. So i was just curious whether we can add that column in Power Query directly/manually or if we dont have any other way then we need to go back in source(Excel file) and need to add that column values in excel. My first preference is to add in query editor that is why i am curious on is there any way to do it in Power BI itself.

 

Thanks

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.