LOADING

Type to search

Calculated column in Microsoft Power BI

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Calculated column in Microsoft Power BI

Share

If you are looking for a Microsoft Power BI Corporate Training in Gurgaon , please feel free to reach out at akriti.lal@instrovate.com or whatsapp at +91-9953805788 

Today I will explain about adding a calculated column in the report. Of course, by this way we will add a physical new column in our data set.

I am proceeding with our last bar chart only:

Calculated column in Microsoft Power BI 29

Go to FIELDS and right click on the data set name

Calculated column in Microsoft Power BI 30

A drop down will appear with different options:

Calculated column in Microsoft Power BI 31

Select New Column and we can see a new field is present.

Calculated column in Microsoft Power BI 32

We can give any name to new column and put formula for this column. For formula we need to select the column name which we want to apply for formula and once formula is entered click on Enter, it will change column name in FIELDS and apply new column to FIELDS:

Calculated column in Microsoft Power BI 33

Let go to Data view to check new Column:

Calculated column in Microsoft Power BI 34

Click on Data

Calculated column in Microsoft Power BI 35

We can see a new column is added with proper calculation.

Go to Report view.

Click on Page to create a duplicate page for this report:

Calculated column in Microsoft Power BI 36

 

Calculated column in Microsoft Power BI 37

Drag Sales field to the Value where unit field is present , it will replace the Sales field with Unit and now Report is with Sales values:

Calculated column in Microsoft Power BI 38

Now we can see which item make more business rather than unit for that item. We can tell in which Region which item done the best business. e.g here in East Region Pencil item is the best item for business & in Central Region Eraser done the best business.

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *