Forum Discussion
Tcerginer
9 years agoRegular Visitor
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...
- 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
Stachu
9 years agoCommunity Champion
BhaveshPatel solution will work, you just need to do it 2 times
1) merging Coworkers with Trail
2) merging 1) with Graduated
Tcerginer
9 years agoRegular Visitor
Thank you very much Stachu BhaveshPatelv-caliao-msft!!
Both solutions helped me a lot! It is working now :D