For more details about the functions used in this recipe, refer to the following links:
- MAXX: https://docs.microsoft.com/en-us/dax/maxx-function-dax
- FILTER: https://docs.microsoft.com/en-us/dax/filter-function-dax
- MAX: https://docs.microsoft.com/en-us/dax/max-function-dax
- LOOKUPVALUE: https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
- BLANK: https://docs.microsoft.com/en-us/dax/blank-function-dax
- ISBLANK: https://docs.microsoft.com/en-us/dax/isblank-function-dax