© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. BoxA Power BI Compendiumhttps://doi.org/10.1007/978-1-4842-9765-0_4

4. Date Calculations

Alison Box1  
(1)
Billingshurst, West Sussex, UK
 

There are not many Power BI reports that don’t require analysis of data over diverse time frames. By leveraging a date dimension and harnessing the time intelligence functions offered by DAX, calculations involving dates are relatively easy to generate. You don’t need to be a DAX guru, for instance, to find the previous year’s or month’s totals. In this chapter, we’ve addressed the most frequently asked questions regarding calculations over time that have arisen from working with our clients or from the Power BI community. ...

Get A Power BI Compendium: Answers to 65 Commonly Asked Questions on Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.