SSAS - tabular exercises on CALCULATED COLUMNS

This page lists the 4 exercises about Calculated columns in SSAS - tabular on our website:

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

You can search our full list of SSAS exercises here, or why not have a look at our other SSAS training resources?

This page has 0 threads Add post