Forum Discussion

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
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

Microsoft Employee

9 years ago

Tested it on my local environment using the sample data below.

We can get the the expected result by using the DAX below.

Column = IF(ISBLANK(LOOKUPVALUE(Table1[Coworkers],Table1[Modules ],Table2[ModulesMustTake],Table1[Coworkers],Table2[Coworkers])),"Due","Completed")

Regards,

Charlie Liao

Super User

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