Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

Related Functions

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? 

Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    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?

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    2 years ago

    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?