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...
Hi Anonymous ,
It is always good to do this in Power Query.
But incase you want to do this as a Calculated Column
First Path =
var sub = SUBSTITUTE('Table'[ColumnValue],"_","|")
RETURN
PATHITEM(sub,1)
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)