#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:
Subscribe to my channel
#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