Forum Discussion

justlogmein's avatar
justlogmein
Icon for Helper III rankHelper III
4 years ago
Solved

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

I have a table of process paths (unique paths through a flowchart) and their assiocitated steps/questions. I have another table of answers to these steps/questions and I need to find which path the a...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.