RELATED function

[Anonymous]

Hi,

one of my table has Many to Many cardinality, and when I try to use RELATED , the option to select coloumn from that table is not there; this means that RELATED cannot work with Many to Many relations, is that a correct assumption.

Thanks,

Siddharth

[v-lili6-msft]

hi  @Anonymous 

RELATED function returns a related value from another table.

For your case, it is a Many to Many cardinality, so you may try RELATEDTABLE Function to create a column as below:

MAXX(RELATEDTABLE('Table'),[Column])

or create a column as below:

CONCATENATEX(RELATEDTABLE('Table'),[Column],",")

Regards,

Lin

[Anonymous]

@v-lili6-msft 

Thanks, these are 2 very useful DAX formulas.

Rgds,

Siddharth

[az38 · Accepted solution]

@Anonymous 

yes, related() can not understand what column is relatedin many-to-many relationships

See remarks here https://docs.microsoft.com/en-Us/dax/related-function-dax