How to Add a New Row in Power BI Table
Adding a new row to a table in Power BI can be accomplished by using the Power Query Editor or by using DAX functions in Power BI Desktop. Here’s how you can do it:
Method 1: Using Power Query Editor
1. Open your Power BI file in Power BI Desktop.
2. In the “Home” tab, click on “Transform Data” to open the Power Query Editor.
3. In the Power Query Editor, find the table you want to add a new row to.
4. Right-click on the table and select “Duplicate” to create a copy of the table.
5. In the duplicated table, change the values in the new row to the desired values.
6. Close the Power Query Editor, and your new row will be added to the table in Power BI.
Method 2: Using DAX Functions
1. Open your Power BI file in Power BI Desktop.
2. In the “Modeling” tab, click on “New Table” to create a new table.
3. In the formula bar, enter a DAX function that generates the values for the new row.
4. Press Enter to create the new row.
5. You can also use the “Add Rows” function, such as “ADDCOLUMNS”, to add a new row with specific column values.
Examples
Example 1: Using Power Query Editor
Suppose you have a table named “Sales” with columns “Product”, “Quantity”, and “Price”. To add a new row:
Product Quantity Price
---------------------------
Apple 10 1.99
Banana 5 0.99
Product Quantity Price
---------------------------
Apple 10 1.99
Banana 5 0.99
NewProd 20 2.99
Example 2: Using DAX Functions
Suppose you want to add a new row with calculated values in a table named “Expenses” with columns “Category” and “Amount”. To create the new row using DAX:
Category Amount
-----------------
Utilities 100
Rent 500
Category Amount
-----------------
Utilities 100
Rent 500
NewCategory SUM(Expenses[Amount])