Check if ID shows up in SEPERATE Table

[Anonymous]

Hello, 

So I have one master table (Table A), that has ID & Tag ID columns, and I want to output the return column:

ID	Tag ID	Return
881	001afd	TRUE
883	003afd	TRUE
789	gqg123	FALSE
4444	0051a	TRUE
54684	1324sa	FALSE
1684	12343	FALSE

And Table B has these columns:

Red	Blue	Green	Brown
001afd	0051a	12lklk	43oorp
002afd	0051b	13lklk	44oorp
003afd	0051c	14lklk	45oorp

Table B shows All Tag ID's split by their color. 

I need to somehow see if Tag ID's from Table A, show up in Table B. If the Tag ID's are in A, then output a TRUE in Table A. 

I am using power query, and don't know how to connect the tables to perfrom this operation. 

Please help!!

Best, 

Senad

[v-yadongf-msft]

Hi @Anonymous ,

Please create a table like below:

Table = union(all('table2'[Red]),all('table2'[Blue]),all('table2'[GreenBrown]))

Then as @amitchandak  said create a new column:

Column = 
Var _cnt = countrows(filter('Table', search('table1'[Tag ID],'Table'[Red],,0) >0 ))
return
if(isblank(_cnt), false(), true())

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous ,

try a new column like

column =

var _tab = union(all(Table1[Red]), all(Table1[Blue]),all(Table1[green]),all(Table1[brownRed]))

Var _cnt = countrows(filter(_tab, search(Table1[Tag ID],_tab[Red],,0) >0 ))

return

if(isblank(_cnt), false(), true())