We have now some worthwhile functions to calculate the previous yr, YTC, etc., in DAX. But other functions allow us to calculate the identical result in another way. Let’s explore our options and why they matter.

After we take a look at the values in a report, we must give them meaning.

Essentially the most common way of doing that is by comparing them with the values of the previous period.

That is when Time Intelligence kicks in as one among the principal things we would like to point out in reports.

For instance, take a look at the next report page:

Here, you may see the comparison of the Sales figures with the previous yr, the 12 months-to-Date, and the rolling total values.

It is a typical report that makes extensive use of Time Intelligence logic.

Now, I’ll show you the best way to create the Measures to calculate these results and the variants using different DAX functions.

I’ll show the outcomes only in tables for higher readability.

We have now numerous Time Intelligence functions in DAX. the dax.guide, we discover a listing of over 35 functions.

Some functions incorporate the entire logic for Time Intelligence, like TOTALYTD() or SAMEPERIODLASTYEAR(). Alternatively, we are able to use more fundamental functions that have to be used at the side of CALCULATE(), like DATEADD() or DATESBETWEEN().

I would like to point out you the best way to use the “easy to make use of” functions after which the best way to use the underlying functions to explore their advantages.

Sometimes, we get different results depending on the used function, and sometimes, we are able to avoid problems through the use of the proper function.

Within the conclusion, I’ll explain why it matters to know different functions and your options to do the calculations.