DAX practice: Calculated Columns vs Measures

Chapter 3 · 4 questions · free to solve

Question 1 · easy
Column or measure?
You want to slice a report by Order Size ('Bulk' or 'Standard'). Should Order Size be a calculated column or a measure?
Solve it in your browser
Question 2 · easy
Line total
Add a calculated column Line Total to Sales: Units multiplied by UnitPrice.
Solve it in your browser
Question 3 · medium
Bulk or standard
Add a calculated column Order Size: 'Bulk' when Units is 30 or more, otherwise 'Standard'.
Solve it in your browser
Question 4 · easy
Order year
Add a calculated column Order Year: the four-digit year of Sales[Date].
Solve it in your browser

These questions are free.

Make a free account to solve them, with instant checking and an AI tutor for hints.

Column or measure?