Calculated column in Microsoft Power BI

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:

Go to FIELDS and right click on the data set name

A drop down will appear with different options:

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

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:

Let go to Data view to check new Column:

Click on Data

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:


 

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:

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.

 

Comments

There are no entries yet.
Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail