Organizing a date table into a hierarchy
Regional managers use a sales chart built on the date hierarchy in the Calendar table. When
they drill into 2026, the chart shows 12 month bars. When they drill into
January, it shows a single bar labeled Q1. Which level order is the hierarchy using?
This exercise is part of the course
Data Ingestion and Semantic Models with Microsoft Fabric
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise