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%
4-star Reviews (1 of 11)
  • Doru Imbroane (Sep 18, 2020)

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