How To Add New Table In Power Bi

How to Add a New Table in Power BI

To add a new table in Power BI, you’ll need to follow these steps:

1. Launch Power BI Desktop, and open your Power BI report or create a new one.
2. In the left sidebar, click on the “Modeling” tab.
3. Click on the “New Table” button in the toolbar.
4. A formula bar will appear, where you can enter a formula or expression to define the new table.
5. For example, let’s say you want to create a new table called “Sales” with columns for “Product”, “Date”, and “Revenue”. In the formula bar, you can enter the following:

             Sales = 
             GENERATE(
               CALENDAR(
                 DATE(2021, 1, 1),
                 DATE(2021, 12, 31)
               ),
               CROSSJOIN(
                 VALUES(Products[Product]),
                 GENERATESERIES(1, 10)
               )
             )
         

   This formula uses the GENERATE and CALENDAR functions to create a date table from January 1st, 2021 to December 31st, 2021. It then performs a CROSSJOIN between the values in the “Products” table and a series from 1 to 10 to generate the “Sales” table.

6. Once you’ve entered the formula, press Enter to create the new table.
7. The new table will now appear in the fields pane on the right side of the screen.

By creating a new table in Power BI, you can combine and transform data to suit your reporting and analysis needs. You can use various functions and expressions to shape the data as required.