Project Botticelli

Table Functions Purchase this course

25 November 2017 · 256 views

Mastering DAX Workshop

The difference between scalar and table functions is that the former returns a single value, the latter returns a table of one or more columns and one or more rows. In this section, you will see the most important table functions in DAX, which are important for internal computations, and are useful when you write a DAX query instead of a DAX expression for a measure or a calculated column:

FILTER Function
ALL Function
ALLEXCEPT Function
Mixing Filters
DISTINCT Function
VALUES and ALLNOBLANKROW Functions
ISEMPTY Function
RELATEDTABLE Function

The learning goal of this module is to introduce you to the notion of table functions and to quickly describe the most important ones, but not to provide a detailed explanation of all the functions yet, as that happens in the later modules. Above all, you will see the interaction between tables and relationships and how to create calculated tables.

Finally, you should practice with Lab 2.

Log in or purchase access below to the premium version of this content.

Purchase This Course or Full Access Subscription

Single Course

$350/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses