For more details on the functions in this recipe, refer to the following links:
- MAX: https://docs.microsoft.com/en-us/dax/max-function-dax
- MIN: https://docs.microsoft.com/en-us/dax/min-function-dax
- MONTH: https://docs.microsoft.com/en-us/dax/month-function-dax
- YEAR: https://docs.microsoft.com/en-us/dax/year-function-dax
- IF: https://docs.microsoft.com/en-us/dax/if-function-dax
- COUNTROWS: https://docs.microsoft.com/en-us/dax/countrows-function-dax
- DISTINCT: https://docs.microsoft.com/en-us/dax/distinct-function-dax
- SELECTCOLUMNS: https://docs.microsoft.com/en-us/dax/distinct-function-dax
- FILTER: https://docs.microsoft.com/en-us/dax/filter-function-dax
- ALL: https://docs.microsoft.com/en-us/dax/all-function-dax
- EXCEPT: https://docs.microsoft.com/en-us/dax/except-function-dax
- COUNTROWS: https://docs.microsoft.com/en-us/dax/countrows-function-dax