Forum Discussion
Solved
Extract string with MID without specifying the number of characters
Hi, I am new to Dax and I need to search for a text strings starting from the fourth character to the end of the string and if the text is there, return some other text. However, my string length...
Alisea_MI , Try a new column like
New column =
var _1 = mid([column],4 , len([column])
return
Switch(true(),
search("ST",_1,,0)>0, "ST",
search("LL",_1,,0)>0, "ST",
search("X",_1,,0)>0, right([column],2)
)
AlexisOlson Unfortunately this gives me an error for the variable. Do you know what problem can be? My column is a text type.
Ah. You have some strings that are shorter than 4 characters.
The MID version of taking the substring is more robust to this issue.