how do i check if a value appears in another table?

[qwertzuiop]

Hello dear PowerBI-Community

I have the following problem to solve.

As shown below, I have 2 tables in PowerBI that I can't edit in advance.

I would like to create another column in table 2 (orange column) and check whether the TransportID appears in the corresponding row in table 1 or not.

Table A:

transportID	…
1	…
2	…
2	…
4	…

Table B:

transportID	…	exists in Table A
1		yes
2		yes
3		no
4		yes
5		no

Any ideas?

I would be very grateful for your help,

Cheers!

qwertzuiop

[Anonymous · Accepted solution]

Hi, @qwertzuiop 

Exists in Table A = CALCULATE(COUNTROWS('Table A'),FILTER('Table A','Table A'[transportID]='Table B'[transportID]))> 0

Best,
Paul