Separating Text from Delimiters

Hi Diptarup 

I'm afraid there is no way to meet your needs .The language we use in Query Editor is M language ,but in the Desktop view , we use DAX .Query Editor cannot identify the column or table that created by DAX .

If the column you provide is a regular column, I think I have a way to achieve the result you want .

Switch to Power Query page , then follow the steps below.

(1)Replace the “A” with “” in column [Activity] .

(2)Replace the value “.1.3.1 luminium” with “.1.3.1 Aluminium” ,because when we are doing the first step, replacing the “A” in the entire column, the latter “A” is also replaced, so we need to add “A” to this value separately .

(3)Add a custom column like this

Activity 1=Text.Select([Activity],{"A".."z"})

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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