In this article, we will talk about calculated columns in Power BI. To prepare any report in real life, we must have to prepare calculated columns and measures in Power BI.
Overview
In this article, we will talk about calculated columns in Power BI. To prepare any report in real life, we must have to prepare calculated columns and measures in Power BI. In this article, we will learn the following topics.
Now, let’s get started!
Calculated Columns
Real Life Scenario for Calculated Columns
To find our month or year from a Date, we can write calculated columns.
Steps to prepare Calculated Column in Power BI.
Step 1
There are two ways to prepare Calculated column in Power BI.
Step 2
It will open a blank formula bar to write an expression.
Step 3
Now, let’s create a Calculated column which will calculate Total Unit Cost.
So, we will write the following formula.
As we can see, a new calculated column is created.
It is a multiplication of Sales Quantity and Unit Cost.
Step 4
We will create some date hierarchy. We will find out the month and the year from the date field.
For that, we will use DAX operation.
Now, let’s create a Calculated column for the year.
How do Calculated Columns consume memory?
Advantages
Disadvantages
Conclusion
This is how calculated column works in Power BI. We will discuss measures in my next article.
Stay Connected with Me!
Pro WPF: Windows Presentation Foundation in .NET 3.0