For more details regarding the functions that were used in this recipe, please 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
- ALL: https://docs.microsoft.com/en-us/dax/all-function-dax
- EARLIER: https://docs.microsoft.com/en-us/dax/earlier-function-dax
- MAXX: https://docs.microsoft.com/en-us/dax/maxx-function-dax
- COUNTROWS: https://docs.microsoft.com/en-us/dax/countrows-function-dax
- IF: https://docs.microsoft.com/en-us/dax/if-function-dax
- ISBLANK: https://docs.microsoft.com/en-us/dax/isblank-function-dax