DAX Patterns: Standard time-related calculations

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

This pattern shows how to compute time-related calculations, like year-to-date, same period last year, and percentage growth using a standard calendar and relying on standard built-in time intelligence DAX functions. The built-in functions are designed in such a way that they provide the correct result for the most common requirements.

In case your requirements cannot be fulfilled by the built-in functions, or if you have a non-standard calendar, 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

  • Standard time-related calculations

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
4.9
13 ratings
92%
8%
0%
0%
0%
5-star Reviews (4 of 5)
  • Ivan Yu (Jun 1, 2021)

    Good patterns.

  • Richard White (Dec 21, 2020)

    Great delivery

  • Feng Wang (Sep 17, 2020)

    Could we have any files for those lectures? Thanks

    • Hello Feng Wang, Thank you for your review! We have created a dedicated page for each pattern on daxpatterns.com with a "downloads" link in the "about this pattern" section on the right hand side. In your case, please visit https://www.daxpatterns.com/standard-time-related-calculations/ to find that link.
      Reply by Claire Costa (Sep 18, 2020)
  • David Johnston (Aug 15, 2020)

    As always, really great content and explanations.