From the course: Excel Business Intelligence: Power Pivot and DAX

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Time intelligence formulas

Time intelligence formulas - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot and DAX

Start my 1-month free trial Buy for my team

Time intelligence formulas

“

- [Instructor] So one of the coolest things about DAX is that they've introduced some incredibly powerful time intelligence formulas. And the thing about these formulas is that it makes it really easy and really turnkey to calculate common time comparisons. So, for example, to calculate Performance-To-Date, you can start with a calculate, evaluate your measure, and then use the DATESYTD function, which simply points to your calendar date field, to produce a year-to-date total for that measure. Now what's even better is that all you need to do is swap out YTD with QTD to update that to quarter-to-date, or MTD for month-to-date. We've also got options to calculate things like the Previous Period, which can be flexible to adjust for any kind of period comparisons you need to make. Things that would be really, really manual and tedious without having access to these tools. So, for Previous Period, you combine calculate with the DATEADD function. And then, at the end there, those two…

Contents