How to Create a Table in Power BI?

Do you know how to create a table in Power BI? This Power BI tutorial will discuss what a Power BI table is and how we can create a new table in Power BI.

Also, I will show you how to create a Power BI table without using DAX and how to create a Power BI table using DAX.

What is a Power BI Table?

In Power BI, a “Table” refers to a data collection organized in rows and columns, similar to an Excel spreadsheet. It is a fundamental component where we store and structure our data.

A table in Power BI is like a virtual table where we can store and manipulate data, making it easier to analyze and visualize our data.

How to Create a Table in Power BI

Create a Table in Power BI

You can create a table in Power BI using the two approaches.

  1. Create a Power BI Table without using DAX
  2. Create a Power BI Table using DAX

1. Create a Power BI Table without using DAX

Now I will tell you step by step how to create a table in Power BI without using DAX:-

1. Open Power BI Desktop. Click the Enter data under the Home tab.

how to create a table in power bi desktop

2. Then the below Create Table dialog box will appear. We use the ‘+‘ symbols to add new columns and rows.

create tables in power bi to add column and row

3. We can add data to the table by typing it into the grid.

how to create a new table in power bi

4. Now, our table is created. Then, specify the table name under the Name field and Click Load.

create a new table in power bi

5. In the Data navigation, you can see the table Product List created.

create table in power bi without using dax

This way, we can create a table in Power BI.

Edit tables in Power BI

In this example, I will show you how to edit the table in Power BI. In the table below, some product names have plural forms, such as Tablets, Televisions, and Smartwatches. I want to change the plural form to a singular one, like Tablet, Television, and Smartwatch.

power bi edit table values

1. Right-click the table name(Product List) to edit the data and select the Edit query option.

how to create a table in power bi manually

2. Then, the power query editor opens. In the APPLIED STEPS on the right side of Query Settings, under Source, click the gear icon.

How to Edit a Table in Power BI

3. To change the product name, double-click on the cell you want to edit and then edit it. After that, click “OK.”

edit data in power bi table

4. Then click the Close & Apply button to apply the changes.

power bi enter data to existing table

In this way, you can edit a table in Power BI.

Add Column and Row in Power BI Table

I want to add another column and row to the Power BI table. [Now, please follow the four steps outlined above in the ‘Edit table in Power BI’ section, referring to the provided screenshot].

  1. Right-click on the table in Power BI Desktop.
  2. Select “Edit Query.”
  3. In the Power Query Editor, locate the Query Settings for that specific table.
  4. Click on the Settings icon under Source.
  5. Add a new row and column using the “+” icon, then enter data.
power bi add column and rows to existing table

6. Here, I am adding a new column(Quantity) and a new row(GameConsol).

power bi add new column and row to existing table

Then click “OK”. In this way, you can add columns and rows to the table.

2. Create a Power BI Table using DAX

Now, I tell you how to create a new table in Power BI using DAX. We can do this using a table constructor. The table constructor is always surrounded by “{}.”

Syntax:

The syntax for the table constructor is:-

New Table = {<value1>,<value2>...}

When only one column in a table, it is called Value. If there are multiple columns, the names are value1, value2,…, valueN.

If we want to add more rows, use the parenthesis “()” and a comma to separate them. We can see below syntax:-

New Table = {
(value1,value2,...,valueN),
(value1,value2,...,valueN)
}

Now, I will show step-by-step using the table constructor to create the table.

1. Click the Table view and the “New table.”

Create table using DAX

2. You can write below the table expression.

New Table = {1}
Creating a Table in Power BI Using DAX Table Constructor

Here, the table name is “New Table” with a single column called “Value,” and a value of 1 is the only row

3. Similarly, if you want the new table with four rows.

New Table = {1,2,3,4}
Power BI Create Table using DAX

4. If you want the new table with four columns, use the parenthesis “().” Check the below DAX.

New Table = {(1,2,3,4)}
how to create a table in power bi with multiple columns

5. Now, we create a table using three columns and three rows.

New Table = {
            (DATE(2023,11,08),"Desktop",CURRENCY(70000)),
            (DATE(2023,06,12),"Laptop",CURRENCY(50000)),
            (DATE(2023,11,10),"Tablet",CURRENCY(55000))
            }
Create a Table in Power BI without using DAX

You can change the column’s name by double-clicking and typing the name. Check the screenshot below.

Change the name of the column in Power BI

This way, you can create a table in Power BI using DAX.

Conclusion

I hope you have followed the steps above to create a Power BI table. In this article, we covered what a table is in Power BI, discussed how to create a table in the Power BI dashboard, explored the process of creating a table using the DAX Table constructor, and explained how to add or edit rows and columns in the Power BI table.

You may also like: