Extend the year dimension
The power of a date or time dimension is that you can extend the dimension by performing calculations one time instead of each time you query the data. For example, you might generate a date dimension which includes holiday information or information specific to your organization, such as fiscal year details or important company dates. In this exercise, you'll learn how to extract and use the decade from the Year
dimension.
If you have lost any progress, close any open reports and load 1_2_extend_year_dimension.pbix
from the Exercises folder on the desktop.
This exercise is part of the course
Intermediate Data Modeling in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
