Related Functions

[M_SBS_6]

Hi, 

I have a many to many join but what I want is to bring a column of data in from one table to another. However, the related function won't work.

The 2 tables are appvalue and appfunds and are joined together on name. I need to bring in the MAX appid from appvalue into appfunds. Any idea how to do this please? 

[OwenAuger · Accepted solution]

Hi @M_SBS_6 

From what you've described, you can create this column in appfunds:

Max appid =
CALCULATE ( MAX ( appvalue[appid] ) )

Does this work as intended?