How To Add Column In Power Bi Query Editor

by

How to Add a Column in Power BI Query Editor

To add a column in Power BI Query Editor, follow these steps:

  1. Open the Power BI Desktop application.
  2. Go to the Home tab.
  3. Click on “Transform data” to open the Query Editor.
  4. In the Query Editor, select the table or query you want to add a column to.
  5. Go to the “Add Column” tab.
  6. Choose the type of column you want to add from the available options.
  7. Configure the column settings as needed. This may include defining a formula or providing values.
  8. Click “OK” to add the column.
  9. Click on “Close & Apply” to go back to Power BI Desktop.

Here’s an example to help illustrate the process:

Let’s say you have a table in Power BI Query Editor that contains data about sales transactions, including the “Quantity” and “Price” columns. You want to add a new calculated column called “Total Sales” that multiplies the Quantity and Price together.

  1. Open Power BI Desktop and go to the Home tab.
  2. Click on “Transform data” to open the Query Editor.
  3. Select the table containing the sales transaction data.
  4. Go to the “Add Column” tab.
  5. Click on “Custom Column” to open the formula editor.
  6. In the formula editor, enter the following formula: Total Sales = [Quantity] * [Price]
  7. Click “OK” to add the column.
  8. Click on “Close & Apply” to go back to Power BI Desktop.

After following these steps, your table will now have a new column named “Total Sales” that calculates the total sales for each transaction.

Leave a comment