Forum Discussion

Tcerginer's avatar
Tcerginer
Regular Visitor
9 years ago
Solved

MATCH between 2 tables

Hello Community,   I am trying to crease a measure using something similar to the MATCH function from excel.   I have a table(1) that tells me which of the company's training modules my coworkers...
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Another solution using Query Editor.

     

    1. Left Outer Join

    2. Conditional Column.

     

    See the attached screenshots.

    LEFT OUTER JOINEXPAND COLUMNCONDITIONAL COLUMNFINAL OUTPUT