Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding Columns in existing table

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
    Anonymous
    5 years ago

    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! 

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , create column and add formula based on row value 

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I dont understand what you are saying.

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

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      This adds same text to all the rows. 

      I have to add 4 different text to 4 rows.

      • Fowmy's avatar
        Fowmy
        Super User
        5 years ago

        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's avatar
    Anonymous
    Not applicable
    5 years ago

    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