Forum Discussion

RichardJ's avatar
RichardJ
Responsive Resident
6 years ago
Solved

Matching a string to a partial string via a relationship

Hi, Please could anyone advise if what I'm asking is technically possible in PowerBI, and the best approach to meet the requirement.   There are two tables: 1) Software Product which contains the...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, I think the best way to solve this is to create an additional table in the model.

     

    SoftwareOrderProducts

     

    OrderIDProduct
    1Product 7
    1Product 7
    2Product 1
    2Product 7
    2Product 8
    2Product 6

     

    Then you create relationships Order - SoftwareOrderProducts and SoftwareOrderProducts - ProductName.

     

    The comma separated string of products coud be transformed to rows in Power Query.

     

    Best Regards / Ulf

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

I believe you would want to use SEARCH or FIND in a column.

Mahyarz's avatar
Mahyarz
Regular Visitor
2 years ago

Sorry, You really did Not get the question!