© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. BoxUp and Running with DAX for Power BI https://doi.org/10.1007/978-1-4842-8188-8_9

9. Calculations on Dates: Using DAX Time Intelligence

Alison Box1  
(1)
Billingshurst, West Sussex, UK
 

Have you ever wanted to compare sales for the current month against sales for last month? Or perhaps something a little more ambitious, such as cumulative totals or even a rolling monthly average? If the answer is yes, and why wouldn’t it be, calculations using date data such as these require the use of a group of DAX functions called “time intelligence” functions. Exploring these functions will be the focus of this chapter, and you will learn how to design expressions to ...

Get Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users 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.