Forum Discussion

jaliu1290's avatar
jaliu1290
Frequent Visitor
1 year ago
Solved

Power Query - Using index of string by delimiter to retrieve string from another column

Hello Power BI Community!   I have an Excel sheet of products with various suppliers and their respective supplier SKU codes which are separated by a "," delimiter.   Each supplier SKU is associa...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    jaliu1290 you can simply achieve this by adding a new custom column in Power Query, make sure the column names are as per table and it is case sensitive.

     

    Text.Split([Supplier SKU], ","){List.PositionOf(Text.Split([Suppliers],","), "ACG")}

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
1 year ago

jaliu1290 you can simply achieve this by adding a new custom column in Power Query, make sure the column names are as per table and it is case sensitive.

 

Text.Split([Supplier SKU], ","){List.PositionOf(Text.Split([Suppliers],","), "ACG")}

 

jaliu1290's avatar
jaliu1290
Frequent Visitor
1 year ago

Brilliant! This worked perfectly, thank you!