Please complete the following exercise before watching this video in which Alberto explains how to solve them:

• 15.30: Many-to-many relationships

You can download all exercise files from here (only available to Full Access Subscribers).

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

14.10: Distinct count of countries
14.20: Sales quantity greater than two

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

The calculation groups feature was released to Analysis Services at the end of 2019 and it is also available in Power BI by using Tabular Editor. Calculation groups modify the behavior of existing measures by replacing the original expression with another one that you can control.

We cover three important filtering topics in this module: ambiguity, arbitrarily shaped filters, and shadow filter context.

In this module you will learn the patterns of the static and dynamic segmentation of the attributes of a table.

Data lineage is important when you need to move a filter from a column over to another column in the model. Using TREATAS, you have the option of changing the data lineage of a table.

In this short module you will learn the details of data lineage, along with some practical examples of the uses of TREATAS.

DAX does not come with any built-in functions providing calculations over hierarchies between attributes and entities. However, the underlying data model can include a definition of hierarchies to be used by client tools to simplify the browsing experience over data.

Almost all data models need to analyze data over time. The first step for handling a date calculation is to create a Date table, which simplifies any date-related calculation. Because of its importance, you should be careful when you create a Date table.

CALCULATE is by far the most important, useful, and complex function in the DAX language, even if the function seems simple by itself. It only performs a few tasks, but the number of scenarios where CALCULATE is necessary, along with the complexity of the formulas that can be written with CALCULATE, make it necessary to dedicate a full, in-depth learning module to it.

The difference between scalar and table functions is that the former returns a single value, whereas the latter returns a table of one or more columns and one or more rows.

In Alberto’s words: DAX is simple, but it is not easy. There are only a few concepts that you need to learn, but you need to learn them well, in-depth, to become proficient. A small investment of your time into learning the beatiful DAX language will reward you with many years of productivity.

This video introduced new features in Power BI that have been added in 2018 and that are relevant to the DAX and the Data Model section of the course.