For more information, refer to the following links: SUBSTITUTE: https://docs.microsoft.com/en-us/dax/substitute-function-dax PATHITEM: https://docs.microsoft.com/en-us/dax/pathitem-function-dax