Forum Discussion

RomainGeniteau's avatar
RomainGeniteau
Regular Visitor
2 years ago
Solved

Search Multiple Value in different columns

Hello,  I'll start by saying that I'm French so my English can be a little messy.  I have a table which contains one identifier column and 4 columns filled with different words like below: Id...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi RomainGeniteau 

     

    For your question, here is the method I provided:

     

    You need a virtual table and go into the power query to do unpivot.

     

    "Table"

     

    " virtual table"

     

    Click "Transform data" to enter the power query.

     

     

    Unpivot columns.

     

     

    Create a relationship.

     

     

     

    Here is the result.

     

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi RomainGeniteau 

 

For your question, here is the method I provided:

 

You need a virtual table and go into the power query to do unpivot.

 

"Table"

 

" virtual table"

 

Click "Transform data" to enter the power query.

 

 

Unpivot columns.

 

 

Create a relationship.

 

 

 

Here is the result.

 

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.