Edit a table creted by add data

[ruthhacche]

Power BI ca be infuriating. I have discovered how to do this twice so far - and forgotten twice (oh, maybe it is my brain that is infuriating?) I have added data into a table manually. I want to amend that data and add another column. But it is not a DAX column - it is just another column of text. Edit table takes me to the query editor which is not what I want. Can someone remind me how I managed to do it last time? Other than copy the table, edit it in excel and then copy it back into a new table and delete the existing one- I don't think that is what I did last time ....

 

[JustynaMK]

I know this feeling!

If you entered data via "Enter Data" option, then you can edit it by going back to Power Query Editor ("Transform Data" button), find your query, go to Applied Steps and press the "cog" icon next to the first step ("Source").

 

[ruthhacche]

I know this feeling!

If you entered data via "Enter Data" option, then you can edit it by going back to Power Query Editor ("Transform Data" button), find your query, go to Applied Steps and press the "cog" icon next to the first step ("Source").

View attachment 9138

Oh you superstar! Thank you.

 

[JustynaMK]

You're welcome! I had exactly the same issue some time ago