From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Time intelligence formulas

Time intelligence formulas - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Time intelligence formulas

“

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, it'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. You'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 combined CALCULATE with the DATEADD function. And then at the end there, those two components of the…

Contents