Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise