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.