Pull a field from a many to many relationship

[TaxiDriveDax]

Hi, 

I am trying to pull value of field from a table to another one. Just that there're connected through  a many to many relationship.

I tested the LookupValue, Relatetable, distinct fonction  but none couldn't get me the expected values.

I then please need other suggestions.

[Anonymous · Accepted solution]

Hi  @TaxiDriveDax ,

I created some data:

TableA:

TableB:

Here are the steps you can follow：

1. Create calculated column.

Flag =
MAXX(
    FILTER(ALL(TableA),
    'TableA'[Column1]=EARLIER('TableB'[Column1])&&
    'TableA'[Column2]=EARLIER('TableB'[Column2])&&
    'TableA'[Column3]=EARLIER('TableB'[Column3])),'TableA'[Column4])

2. Result:

Best Regards,

Liu Yang

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

[TaxiDriveDax]

sure :

TABLE A is related to TABLE B on a many to many Relationship.

Table A
Column1	Column2	Column3	Column4 (type Text)

Then the expect result is to have in TABLE B the below Structure

Table B
Column1	Column2	Column3	CalculateColumn (Table A.Column4)

[FreemanZ]

hi @TaxiDriveDax 

could you paste some sample data?