Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Related function doesn't work

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 "D...
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

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.