DAX Patterns: Month-related calculations

These are in-depth video lectures of the Month-related calculations pattern.

This pattern describes how to compute month-related calculations such as year-to-date, same period last year, and percentage growth using a month granularity. This pattern does not rely on DAX built-in time intelligence functions.

You can use the Month-related calculations pattern if the analysis over sales is executed at the month level (or above) only. In other words, the formulas stop working if you drill down to the date level. Because the pattern does not use real dates to link to sales, you can also implement fiscal calendars with 13 months and any non-standard time-related calculation – provided that the maximum level of detail of the reports is the month and not weeks or days.

In case your requirements cannot be fulfilled by month-related calculations at the month granularity, then you should use another pattern. Check the Time-related calculations introduction to figure out what is the right pattern for your scenario.

Collapse allCurriculum

  • Month-related calculations

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
5.0
9 ratings
0%
0%
0%
0%
Student Reviews (5)
  • Genadiy Tsvetkov (Dec 20, 2023)

    Outstanding! Very Advanced topics and explained so thoroughly.

  • Deborah Compton (Sep 24, 2023)

    Great content as usual, might be a good addition to do a video on how the date table is created. I know that the code is in the file but having a video walkthrough would be beneficial.

  • carlos barboza (Feb 20, 2021)

    Excellent course for those who need implement custom calendars. For example, for our accounting fellas who sometime recur to 13 months period evaluations.

  • Richard White (Dec 21, 2020)

    Great video

  • Refa Abay (Oct 24, 2020)

    Everything explained so comprehensively that I would like to thank you once again. Extremely practical.