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 ...
Need Help
  • camargos88's avatar
    camargos88
    5 years ago

    Anonymous ,

     

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

camargos88's avatar
camargos88
Community Champion
5 years ago

Anonymous ,

 

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

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