The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

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

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

Recommended additional resources

Watch the rest of the DAX 101 video series:

Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents