For more details regarding the functions in this recipe, refer to the following links: ADDCOLUMNS: https://docs.microsoft.com/en-us/dax/addcolumns-function-dax FILTER: https://docs.microsoft.com/en-us/dax/filter-function-dax CALENDAR: https://docs.microsoft.com/en-us/dax/calendar-function-dax AVERAGEX: https://docs.microsoft.com/en-us/dax/averagex-function-dax