Adding New Column in Power BI existence query

Question

Could you pls advise : How to add a new Column in Power BI existence query, not column as per example , not calculated column etc, just simple column as in EXCEL to input data

Answer 1

Hello there,

In Power BI, you can add a new column to an existing query using the Power Query Editor. This new column can contain input data that you can manually enter, similar to how you would add data to a column in Excel. Here's how you can do it:

Open Power Query Editor:

In Power BI Desktop, go to the "Home" tab on the ribbon.

Click on "Transform data" to open the Power Query Editor.

Select Query:

In the Power Query Editor, select the query to which you want to add a new column.

Add Custom Column:

In the Power Query Editor, select the "Add Column" tab on the ribbon.

Click on "Custom Column."

Name Column:

In the "Custom Column" dialog, give your new column a name. This will be the name of the column that you'll use in your query.

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–