Home
Do you know the difference between Calculated Columns and Measures in Power BI?
  v1.0 Posted at 24/10/2016 5:19 PM by Ulysses Maclaren
When you run into a wall in Power BI and feel like you've exhausted the out of the box functionality, that when it's time to investigate what a bit of DAX can do for you. 

There are 2 different things​ you can do with DAX, create a Measure or a Calculated Column.​

Calculated columns:

  • Stored in the database
  • Often used to filter/group data

Measures:

  • Computed on aggregates of values
  • Computed at query time
  • Often used to give a numerical metric

GroupingColumn = if(value<x, small, if(value<y, medium, large))

Figure - Good Example: Nested if statements are a great way to split up your data into groups

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments:

    Note: Social Media login for Yotpo is not working in IE or Safari, please use Chrome. We are waiting for Yotpo to fix it.