Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

multiful condition vlookup

 

 

Good afternoon,

 

I want to take talbe 2 ROS date on table 1.

it should match module and group. any ideas?

 

thanks for any help in advance.

<Table1>

<Table2>

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Since i don't know your data from Table1, I can't make a test to achieve it.

    Please re-upload the picture if my assumption below is not correct.

     

    If table1 and table2 all have "module and group" columns,

    You could merge columns for "module and group", then merge two tables based on the merged column in both tables.

    Open Home-Edit Queries,

    Merge columns in Power BI

    Merge queries In Power BI

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.