Power BI – Create custom columns

Operate on multiple columns and place the result in a new column in Power BI called a custom column. Let us consider the previous example.

Input File: Profit.xlsx
Output Saved as: Amit Pivoted Column.pbix

Click the Add Column tab and then click Custom Column:

Create a custom column in Power BI

Just for the example, consider the 1st quarter profits i.e., Jan – March.

We will display the result of Quarter 1 profit in the new column.

Therefore, the new custom column name is set to ProftQuarter1 by us. From the Available Columns, we have clicked Insert to drag the January, February, and March columns one by one. These get added to the Custom column formula.  We will just add them to get the Quarte 1 profits:

Here is the screenshot. Click OK:

Set the custom column formulae in Power BI

The result is returned and a new custom column ProfitQuarter1 added successfully.

Custom column added in Power BI

Now, we have the quarter profits for each year. On the right, in the Query Settings section, the changes are visible i.e. Added Custom Rows under the APPLIED STEPS.


If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.


For Videos, Join Our YouTube Channel: Join Now


Read More:

Power BI - Pivot columns
Power BI - What is DAX
Studyopedia Editorial Staff
contact@studyopedia.com

We work to create programming tutorials for all.

No Comments

Post A Comment

Discover more from Studyopedia

Subscribe now to keep reading and get access to the full archive.

Continue reading