#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:



#1 DAX Fridays! 101: The basics of the DAX Language

#2 DAX Fridays! 101: Introduction to filter and row context

#3 Dax Fridays! 101: 5 things i wish somebody told me when I started learning DAX

#4 DAX Fridays! 101: What is Context transition in DAX?

#5 DAX Fridays! 101: Order of evaluation for DAX formulas

#6 DAX Fridays! 101: Scalar vs table vs other functions – Explaining common DAX errors.

My beginner's DAX mistakes, ……what are yours? 😈

DAX Fridays #193: Why is DAX so difficult to learn?

Was this helpful?
Reader Interactions