EXERCISE TOPIC▼
- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
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