DAX practice: Variables for Performance & Clean Code
Chapter 18 · 3 questions · included in full access
Question 1 · easy
When a VAR is computed
Solve it in your browserWhen is a DAX variable evaluated?
Question 2 · medium
Margin with variables
Solve it in your browserWrite Margin % using VAR / RETURN: capture [Total Sales] and [Total Cost], then divide (Sales - Cost) by Sales.
Question 3 · medium
Net profit
Solve it in your browserWrite Net Profit using VAR / RETURN: capture Rev = [Total Sales] and Exp = [Total Cost], then return Rev - Exp.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing