For more details regarding the functions in this recipe, refer to the following links: FIRSTNONBLANK: https://docs.microsoft.com/en-us/dax/firstnonblank-function-dax LASTNONBLANK: https://docs.microsoft.com/en-us/dax/lastnonblank-function-dax