WISE OWL EXERCISES
SSAS EXERCISES
SSAS - TABULAR EXERCISES
- Creating a data model (2)
- Excel pivot tables (1)
- PowerView (2)
- Power BI Desktop overview (1)
- Other data sources (1)
- Calculated columns (4)
- Measures (3)
- Changing query context (2)
- The EARLIER Function (1)
- DAX queries (3)
- Date calculations (3)
- Hierarchies (1)
- KPIs (2)
- Perspectives (1)
- Prototyping using PowerPivot (1)
- Security (2)
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. |
| 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. |
| 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. |
| 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. |
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