What is the difference between DAX functions, expressions, and variables
Loading
What is the difference between DAX functions, expressions, and variables
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rijwan AnsariPosted Dec 31, 2024, 5:51 AM
In Data Analysis Expressions (DAX), functions, expressions, and variables are used to perform calculations and queries on data:
DAX functions
Contain numerical and nonnumerical values, and can include nested functions. DAX functions can return a table or a scalar.
DAX expressions
Always start with an equal sign (=) and can contain operators, constants, or references to columns.
DAX variables
Store DAX logic that can be used later in DAX code. Variables can help improve query performance and reduce the number of times complex calculations are recalculated.