Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics

© Dan Clark 2020

D. ClarkBeginning Microsoft Power BIhttps://doi.org/10.1007/978-1-4842-5620-6_7

7. Incorporating Time Intelligence

Dan Clark¹ 

(1)

Camp Hill, PA, USA

 

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