Do you know the difference between Calculated Columns and Measures in Power BI?
Rules to Better Power BI|13da41ff-0500-4d3f-b5eb-6548633846e1
v1.0
Posted at
24/10/2016 5:19 PM by
Ulysses Maclaren
Rule Intro
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.
Page Content
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
{0EA58893-E64E-42B4-81BB-BE2A2612F046}
Do you feel this rule needs an update?