If you are looking for a Microsoft Power BI Corporate Training in Gurgaon , please feel free to reach out at firstname.lastname@example.org 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.
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 - email@example.com if you would like to know more .