For more details regarding functions in this recipe, refer to the following links:
- SEARCH: https://docs.microsoft.com/en-us/dax/search-function-dax
- BLANK: https://docs.microsoft.com/en-us/dax/blank-function-dax
- ISBLANK: https://docs.microsoft.com/en-us/dax/isblank-function-dax
- LEN: https://docs.microsoft.com/en-us/dax/len-function-dax
- MID:: https://docs.microsoft.com/en-us/dax/mid-function-dax
- FIND: https://docs.microsoft.com/en-us/dax/find-function-dax
- RIGHT: https://docs.microsoft.com/en-us/dax/right-function-dax
- LEFT: https://docs.microsoft.com/en-us/dax/left-function-dax