Rules

Secret ingredients to quality software

Edit
Info

Do you know the difference between Calculated Columns and Measures in Power BI?

Last updated by Ulysses Maclaren on 24 Oct 2016 06:19 am (over 4 years ago) See History

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


We open source. This page is on GitHub