Ref Ref of Parent

[Geovanni_Gerard]

I dont know how to explain what I need. So be patient .

I have three tables :
Parent Table
Children Type A
Children Type B

Both types of children share the Parent ID. For specific gadget I need to take a column of Children A in Children B .

So What I am trying to get it is something like this.

[Parent ID].[Children A].[Column A] WHERE Children A[Parent ID] = Children B [Parent ID]

Regards,

Geovanni Rojas

[Steve]

So you want the value of the Column A column in the Children A table for all rows of Children A whose Parent ID also occurs in a row of Children B?

SELECT(
  Children A[Column A],
  IN([Parent ID], Children B[Parent ID])
)

[Geovanni_Gerard]

Steve:

IN([Parent ID], Children B[Parent ID])

THIS NOT WORK , LITERALLY IT IGNORES THE CONDITION OF SAME PARENT ID , ANY IDEAS ?

[Steve]

You need to state your requirements more clearly. I had to guess what you wanted, and you shouted at me that I was wrong.

[Geovanni_Gerard]

Sorry, I did not try to shoot you , it just I had the uppercase activate.

I just figure it how to do it. I will write my code just if someone need it.

SELECT(Children B[Column desire], [_THISROW].[Parent ID]= [Parent Id])

With your code I was getting a list, the big differences made the “Thisrow” that gives me a list but just of the related .

Thanks .