Forum Discussion
Trim Function
I wanted to delete specific strings from the data. But the data is not consistent. sample data 123456_1 123456_10 1234568_01 1234567_1 I need to remove the last strings ( which are highli...
If you want to use a measure you can try
New String =
VAR EvalString = SELECTEDVALUE('Table'[Column1])
VAR LenTo = FIND("_" , EvalString, 1, LEN(EvalString)) - 1
RETURN MID(EvalString, 1, LenTo)