Microsoft SSAS - tabular training exercises | Calculated columns

Showing exercises 1-4 (out of 4)

Category: SSAS - tabular
Topic: Calculated columns
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Bring columns from different tables into a single table using the RELATED function.

Go to exercise ...

Category: SSAS - tabular
Topic: Calculated columns
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Create 3 calculated columns using & (concatenation), the YEAR function and the SWITCH function.

Go to exercise ...

Category: SSAS - tabular
Topic: Calculated columns
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Count the number of rows in a related table, using the RELATEDTABLE function.

Go to exercise ...

Category: SSAS - tabular
Topic: Calculated columns
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Use the ISBLANK and RELATED functions to show missing parent rows.

Go to exercise ...

This page has 0 threads Add post