Forum Discussion
How do you lookup?
I want a table that shows the "analysenaam" where no parameter can be found from the secondtable (globaalplan) So in my example it would be "D" because test 1, test 2 and test 3 cannot be found ...
Hi Anonymous ,
You can also create a measure using DAX formula to implement it. I create a sample you can have a try.
Measure = IF(NOT(MAX(Table1[Paramter]) in VALUES(Table2[Paramter])),MAX(Table1[analysenaam]),0)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What you want to do is through the Query Editor.
Merge the queries as New and select "Left Anti" as the join type on the "Parameter" column.
I cannot merge because there is not a direct relationship as shown in the screenshot below how should i work around this?