Enter your email to track your progress and stay up-to-date on new Power BI learning content.
By clicking Track progress, you are giving your consent to Microsoft to provide you updates about Power BI learning resources via email. You can unsubscribe at any time.
As you progress through Guided Learning, a green checkmark will appear next to your completed topics.
With an introduction complete, get ready to dive deep!
Using variables are an extremely powerful part of a DAX expression.
You can define a variable anywhere in a DAX expression, using the following syntax:
VARNAME = RETURNEDVALUE
Variables can be any data type, including entire tables.
Keep in mind that each time you reference a variable in your DAX expression, Power BI must recalculate its value according to your definition. For this reason, it's good practice to avoid repeating variables in your function.
Video content courtesy of Alberto Ferrari, SQLBI