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 BI. 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 ...
