Adding Columns in existing table

[Anonymous]

I have 4 rows and 4 column data, to which I have to add extra column and enter text there.

How to do it?

Shall I use M code Table.Addcolumn? What will be the syntax to insert text?

I cannot create another table and merge because there is no relation.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

You can add a column of Sheet2 in your original Excel, the data in it is your column that is not loaded in, and a primary key column

For example:

Sheet1：

Sheet2: The Score column is not loaded into the column

Use the same ID column as the primary key column, load this Excel into power bi

Here are the steps you can follow：

1. Enter Power query through Transform data, select Home – Merge Queries – Merge Queries.

2. Select the [ID] column of Sheet1 and the [ID] column of Sheet2, and select Join Kind as Left Outer.

3. Select the column to load into.

4. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Hi  @Anonymous ,

You can add a column of Sheet2 in your original Excel, the data in it is your column that is not loaded in, and a primary key column

For example:

Sheet1：

Sheet2: The Score column is not loaded into the column

Use the same ID column as the primary key column, load this Excel into power bi

Here are the steps you can follow：

1. Enter Power query through Transform data, select Home – Merge Queries – Merge Queries.

2. Select the [ID] column of Sheet1 and the [ID] column of Sheet2, and select Join Kind as Left Outer.

3. Select the column to load into.

4. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Fowmy]

@Anonymous 

To add a custom column in Power Query, click on the Custom Column under Add Column Tab and enter as follows.

[Anonymous]

This adds same text to all the rows. 

I have to add 4 different text to 4 rows.

[Fowmy]

@Anonymous 

Sorry, your explanation was not clear enough.  If you want to add different text then you need have a condition to check. you can for exmaple use IF as follows 

=if [Column] = "condition" then "your text" else null

[Anonymous]

I dont have a condition here.

I imported a excel file and one column which was text was not loaded into query editor. Now, i want to add this column manually.

I cannot create new table and merge it since there is no relation.

[Anonymous · Accepted solution]

I made changes into the excel file and the problem is resolved.

But, its not possible to add cloumn containing different text for each row in power bi. I didn't find solution for this! 

[amitchandak]

@Anonymous , create column and add formula based on row value 

if [col] =1 then "A" else "B" end

[Anonymous]

I dont understand what you are saying.

Do I have to add column in query editor? If yes, then is it custom column?