Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Substring Text based on delimiter position defined in another column

Hi Guys,

 

I want to extract some text from a column based on the position of a delimter defined in another column.

Example of data

 

 

 

 

 

 

 

So i want all three Names column to be populated from values extracted from column FD.

Level columns define the position of delimter i.e. "_" after which the name exist for that particular column.

I would also like to handle the blank values the same way was mentioned in the table.

 

I am looking for a function in DAX to populate these column but incase you know how it's done in Power query that's also fine.

 

Any help in this regard will be highly appreciated.

 

Thanks,

 

Uzair

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      camargos88 Thanks.

       

      It's funny that I just found the similar solution. I used the below code which apparently do the trick.

      if [FruitLevel] <> null then ( Text.Split([FD], "_"){[FruitLevel]}) else null

      The main problem is those levels columns are created using DAX Lookup, so I don't think I can use those columns with Power Query function.

       

      Do you have any idea how can I achieve this ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ashish_Mathur  Thanks for the help.

       

      I am going with the camargos88  solution. But that's neat trick you did with keyword.