Curbal has its own social media server on Mastodon. Check it out here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.


#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