#6 Scalar vs table vs other functions in DAX
Why do you get errors when you use some DAX functions as a measure or table or calculated column?
Table of contents:
In today’s video, we will explain the difference between scalar vs table vs other functions and explain the following errors:
1. Error when a table is expected but a value is returned
2. The expression specified in the query is not a valid table expression.
3.The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value or
4. EARLIER/EARLIEST refers to an earlier row context which doesn’t exist.
Watch the tutorial:
Recommended additional resources
Watch the rest of the DAX 101 video series: