Doing a Vlookup but for data in groups (Excel Power Query/DAX)

Hi justlogmein ,

Does Thingsclump 's solution help you?

According to his solution, after merging, you can filter Group as i and PARTID as 1 to get the desired result.

Or you can create a calculated table using DAX.

Before you use the CROSSJOIN function, make sure that the column names of the two tables do not have the same name. Here I have modified the names of the Old Process Step ID.

Table =
FILTER (
    CROSSJOIN ( 'Question Mapping', 'Response List' ),
    [Old Process Step ID question] = [Old Process Step ID response]
)

After filtering, the result is as follows.

Best Regards,

Stephen Tao

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