Adding Column In Virtual Table

A calculated table can be created using AddColumns. However, employing it inside a measure is the most typical application. AddColumns is a tabular function, hence additional functions are required in order to use it in a measure.

Step 1: To work with virtual tables, use the Power BI Desktop application and choose the report or dataset.

Step 2: Make sure you are in either the “Data” view or the “Report” view, which will allow you to access the “Fields” pane and the “Formula bar.”

Step 3: To add a new measure or calculated column, click the “New Measure” button in the “Fields” pane.

Step 4: You can create virtual tables and add columns using DAX expressions and functions in the formula bar. Here’s an illustration:

VirtualTableWithColumns =
VAR VirtualTable =
    SUMMARIZE(
        SalesTable,
        SalesTable[Category],
        "Total Sales", SUM(SalesTable[SalesAmount]),
        "Avg Sales", AVERAGE(SalesTable[SalesAmount])
    )
RETURN
VirtualTable

In this illustration, a virtual table called “VirtualTable” is made from the SalesTable using the SUMMARISE function. The VirtualTable has three columns in addition to the “Category” column: “Total Sales” and “Avg Sales,” which are calculated using the SUM and AVERAGE functions, respectively.

Step 5: Enter will evaluate the formula and generate the fictitious table.

Power BI is used for the analyses of all the business-related factors and for calculating different factors which are of prime importance in business running. The data can be stored in separate tables where many columns can be used to represent different data types. In this article, we will learn how to create new columns in your report using Power BI Software.

Here we will discuss 4 types of Adding Columns in Power BI Desktop

• Add New Columns in Power BI
• Add a Custom Column in Power BI
• Adding Column In Virtual Table
• AddColumns DAX Tabular Function