cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Enter Data Column

Hi all,

 

Is it possible to enter a column and enter the data in query editor?

 

For example below I would like to have a column and be able to enter values in the fields in query editor

 

Capture.PNG

4 REPLIES 4
Highlighted
Super User V
Super User V

Re: Enter Data Column

Hi @HenryJS ,

 

You can enter manual data inside a custom column using some functions (table / record / list).

 

However, it's easier if you input a table with the values and merge (using Power Query) or relate them (using relationship).

 

Can you give more details about what you need ?



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

Proud to be a Super User!



Highlighted
Super User II
Super User II

Re: Enter Data Column

Hi @HenryJS ,

 

Not sure I fully understand your requirement here. If you mean you want to literally type values into cells like Excel then, no, this isn't possible. There are a couple of other options though, although both depend on your being able to define the row location of your new value:

 

1) Create a new table with your desired values, and a second column (or more) that you can use to join it to your main table, then join.

2) Create a conditional column and define that when a row meets certain criteria, have your new value be the result.

 

Pete

Highlighted
Post Prodigy
Post Prodigy

Re: Enter Data Column

@HenryJS  Hi Henry, yes it is possible to add coluumn in power query window. Under the Add Column Tab select Column from Examples -> From Selection. Now one column would be added in the window, you can paste values and then select Ok.

Highlighted
Post Prodigy
Post Prodigy

Re: Enter Data Column

@negi007 is it possible to go back to the entering values as it first showed after you've created the column?

 

When i clicked edit on the cog it just took me to this window

 

thanks

 

Capture.PNG

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors