Related function doesn't work

[Syndicate_Admin]

Hi fellows, I hope you can help me.

I have the following tables:

As you can see both contain the "Document" column and are related as follows:

I want to extract from the table "DM" the value "DX Date" and place it in the table "BD DTC", but when I try I get the following error: The column 'DM[DATE DX]' does not exist or has no relation to the tables available in the current context.

Any idea what might be going on?

[V-lianl-msft · Accepted solution]

Hi @Syndicate_Admin ,

RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE or LOOKUPVALUE.

Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('DM'),"DX",'DM[DATE DX]'),TRUE())

lookupvalue-function-dax 

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