Substring Text based on delimiter position defined in another column

[uzairsattar]

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

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[uzairsattar]

@Ashish_Mathur  Thanks for the help.

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

[camargos88 · Accepted solution]

@uzairsattar ,

Check the attached file, the result it's different but I believe it can help you.

[uzairsattar]

@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 ?