Forum Discussion
SUBSITUTE function does not work correctly in DirectQuery mode
Hello everyone, I would like to find a solution for a problem regarding the SUBSITUTE function. I have a string of procceses in the following format: [|Process1|,|Process2|,|Proces3|, ...] ...
Anonymous Any chance you can use a measure? More DAX functions are supported in measures rather than calculated columns. Also, if you can use SUBSTITUTE in a measure and replace all occurences with "|" (pipe character) then you can use PATHITEM to retrieve individual parts instead of using FIND, MID, etc.
The errors is:
Function 'SUBSTITUTE' is not allowed as part of calculated column DAX expressions on DirectQuery expressions on DirectQuery models.