How To Add New Column In Power Bi

How to Add a New Column in Power BI

Adding a new column in Power BI is a simple process that allows for the creation of customized calculations or transformations based on existing data. Here’s how you can do it:

1. Open your Power BI Desktop application and load the desired dataset.
2. In the “Fields” pane on the right-hand side, locate the table where you want to add the new column.
3. Right-click on the table name and select “Edit Queries.”
4. The Power Query Editor window will open, displaying the existing columns and data transformations.
5. Click on the “Add Column” tab in the Power Query Editor toolbar.
6. Choose the type of column you want to add. There are several options available, including:
• Custom Column: Allows you to create a new column based on a formula or expression. For example, you can concatenate two text columns using the formula “=[Column1] & [Column2].”
• Duplicate Column: Creates an exact copy of an existing column.
• Column from Examples: Enables you to generate a new column by providing example values for the first few rows.
• Conditional Column: Helps you create a new column based on specified conditions. For instance, you can create a column that assigns a “High” or “Low” rating based on a numerical value.
7. Once you’ve selected the desired type, follow the prompts to configure the column settings and formula.
8. Click “OK” to add the new column.
9. Review the changes made in the Power Query Editor and click “Close & Apply” to apply the changes to your Power BI report.
10. The new column will now be available for use in visualizations or further data analysis within Power BI.

Example:

Let’s say you have a dataset containing information about sales transactions. You want to add a new column to calculate the total revenue per transaction. Follow the steps mentioned above and select the “Custom Column” type. Use the formula “=[Quantity] * [Price]” to multiply the quantity and price columns. After clicking “OK” and applying the changes, you will have a new column representing the total revenue for each transaction.