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 in Power BI by Roshni
• 5,990 points
11,385 views

1 answer 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.

For more information you can follow this docs, 

https://docs.microsoft.com/en-us/power-bi/desktop-add-custom-column

answered Feb 3 by Rajan

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 3 in Power BI by ggm
• 140 points
330 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
• 51,970 points
515 views
0 votes
1 answer

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

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,490 points
10,528 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
440 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
• 32,490 points
172 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4 in Power BI by Roshni
• 5,990 points
91 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 in Power BI by Gitika
• 48,560 points
1,681 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 in Power BI by Gitika
• 48,560 points
807 views
+3 votes
1 answer

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
• 32,490 points
40,124 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 in Power BI by Jitesh
4,738 views