How to add an extra column to the existing table in power bi query editor

0 votes
I am trying to add an extra column to the existing table in power bi query editor, but not getting any idea how can I do it. Can anyone explain the process?
Feb 3, 2020 in Power BI by Roshni
• 10,520 points
76,638 views

3 answers to this question.

0 votes

Hi,

To create a custom column, we need to follow some steps:

  1. First, we need to Launch Power BI Desktop and load some data.
  2. Once you launch Power BI Desktop then, from the Home tab on the ribbon, select Edit Queries, and then select Edit Queries from the menu.
  3. Then, from the Add Column tab on the ribbon, select Custom Column. 
  4. Once you select Custom Column, then you will get to see a list of columns and in the Available columns list on the right.
  5. You can see New column name box. You can rename this column.
  6. In the Custom column formula box. You create these queries by building the formula on which your new custom column is defined.

To create formulas for your custom column:

  1. Select a column from the Available columns list on the right, and then select Insert below the list to add them to the custom column formula.
  2. As you enter the formula and build your column, note the indicator in the bottom of the Add Custom Column window.
  3. Select OK.

*Power BI Desktop adds your custom column to the model, and adds the Added Custom step to your query's Applied Steps list in Query Settings.

Unlock the Power of Data with Our Comprehensive Power BI Training!

answered Feb 3, 2020 by Rajan
0 votes

Use Query Editor to add a custom column

To start creating a custom column, follow these steps:

  1. Launch Power BI Desktop and load some data.

  2. From the Home tab on the ribbon, select Edit Queries, and then select Edit Queries from the menu.

  3. From the Add Column tab on the ribbon, select Custom Column.

  4. The Add Custom Column window appears.

  5. The Add Custom Column window

    The Add Custom Column window has the following features:

  6. A list of available columns, in the Available columns list on the right.

  7. The initial name of your custom column, in the New column name box. You can rename this column.

  8. PowerQuery M formula queries, in the Custom column formula box. You create these queries by building the formula on which your new custom column is defined.

  9. Create formulas for your custom column

  10. Select a column from the Available columns list on the right, and then select Insert below the list to add them to the custom column formula. You can also add a column by double-clicking it in the list.

  11. As you enter the formula and build your column, note the indicator in the bottom of the Add Custom Column window.

    If there are no errors, you'll see a green check mark and the message No syntax errors have been detected.

  12. If there's a syntax error, you'll see a yellow warning icon, along with a link to where the error occurred in your formula.

  13. Select OK.

    Power BI Desktop adds your custom column to the model, and adds the Added Custom step to your query's Applied Steps list in Query Settings.

  14. To modify your custom column, double-click the Added Custom step in the Applied Steps list.

    The Add Custom Column window appears with the custom column formula you created.

answered Dec 16, 2020 by Gitika
• 65,910 points
0 votes

Click on edit queries after loading source file to power bi.

  1. Using 'Enter Data' button entered sample data you provided and created new table. ...
  2. Expand Table - In the original table expand the merged table. ...
  3. You can always change data(add new columns/rows) manually in new table by clicking on gear button next to source.

answered Dec 16, 2020 by Roshni
• 10,520 points

Related Questions In Power BI

0 votes
0 answers

How to group rows in Power BI query editor?

Can someone explain the steps how can ...READ MORE

Feb 4, 2020 in Power BI by ggm
• 140 points
1,044 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,360 points
1,167 views
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,910 points
53,367 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
1,253 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
898 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,180 points
560 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,910 points
11,172 views
0 votes
1 answer

How to make a table Hyperlink in Excel Power Pivot?

Hey, You can follow these steps to make a ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,910 points
5,580 views
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
151,957 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
18,457 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP