One of the most common types of data analysis is comparing values over time. This chapter shows you how to correctly implement time-based analysis in Power Pivot. It includes setting up a date table and using the various built-in functions for analyzing values to date, comparing values from different periods, and performing semi-additive aggregations.
After completing this chapter, you will be able to
Create a date table.
Use DAX for time period-based evaluations.
Shift the date context using filter functions.
Create semi-additive measures.
Date-Based Analysis
A large percentage of data analysis involves ...
