Power Bi - Create a Calculated Field

Today is my first time using Power Bi and its very weird to use. But one thing I do find better is that I can move the charts wherever I want unlike in tableau - my dreaded containers.

I was using sample superstore to play around with in Power Bi.

I wanted to create a map that shows the states with the profitability and unprofitability - the issue I came across was creating a calculated field.

How to create a calculated field:

You need to create a new column in the dataset - to do so:

A new window will pop up: This is where you will create your new column.

The Orange circle - ' Custom Column' will enable you to create any calculated field. The green box - ' Conditional Column' will allow you to do conditional statements such as IF statements 

Conditional Statements:

Any other Calculations:

Once you have hit 'OK'

Go back to the original window of Power Bi and this yellow banner will appear. Hit Apply changes -> the new column will appear in the right hand field pane which you can now use

Author:
Maha Hussari
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab