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