Forum Discussion
Adding Columns in existing table
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
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!
Anonymous
To add a custom column in Power Query, click on the Custom Column under Add Column Tab and enter as follows.
This adds same text to all the rows.
I have to add 4 different text to 4 rows.
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 nullI 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.
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!