Substring from an exited column

Hi Anonymous ,

We can use two ways to meet your requirement.

1. In Power Query, we can use the split column function.

2. Or we can create a calculate column to split it.

Prodcutnew = 
var len__ = LEN('Table'[Product])
var location__ = FIND("-",'Table'[Product],1,0)
return
RIGHT('Table'[Product],len__ - location__)

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.