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 DATE CALCULATIONS
This page lists the 3 exercises about Date calculations in SSAS - tabular on our website:
| Software: | SSAS - tabular |
| Version: | SSAS 2012 and later |
| Topic: | Date calculations |
| Level: | Relatively easy |
| Course: | SSAS - Tabular Model |
| Exercise: | Use the TOTALYTD and TOTALQTD to calculate and show cumulative yearly and quarterly totals. |
| Software: | SSAS - tabular |
| Version: | SSAS 2012 and later |
| Topic: | Date calculations |
| Level: | Relatively easy |
| Course: | SSAS - Tabular Model |
| Exercise: | Use the SAMEPERIODLASTYEAR and DATEADD functions to calculate and show totals. |
| Software: | SSAS - tabular |
| Version: | SSAS 2012 and later |
| Topic: | Date calculations |
| Level: | Average difficulty |
| Course: | SSAS - Tabular Model |
| Exercise: | Use various DAX calendar-based functions to return interesting statistics!. |
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