Accept cookies to show this video. Cookies Policy
Allow all cookies

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

    • About the Standard time-related calculations pattern
    • Introduction
    • Building a Date table
    • Computing period-to-date totals
    • Computing period-over-period growth
    • Computing period-to-date growth
    • Comparing period-to-date with previous full period
    • Using moving annual total calculations
    • Moving averages
    • Filtering other date attributes

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
4.9
22 ratings
91%
9%
0%
0%
0%
Student Reviews (11)
  • Genadiy Tsvetkov (Dec 19, 2023)

    Just an outstanding collection of typical time-related calculations. Fantastic!

  • Kok Leong Ong (Jul 26, 2023)

    good teaching!

  • Kok Leong Ong (Apr 9, 2023)

    Clear explanation! I love this course it is very professionally explained!

  • Anna Bancyr (Jan 27, 2022)

    Im sorry it just needed more time than i expected to appear. All works just fine

  • Anna Bancyr (Jan 27, 2022)

    Its a piti that discussion section displays error

  • RAUL PARRA PARRADO (Oct 5, 2021)

    The course seemed very practical and easy to understand. The examples used are the ones one encounters in real life

  • Ivan Yu (Jun 1, 2021)

    Good patterns.

  • Richard White (Dec 21, 2020)

    Great delivery

  • Doru Imbroane (Sep 18, 2020)

    It would be advantageous if you spend little time explaining the functions used (just as a reminder).

  • 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.