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

Tell a Friend about this

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: