Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago

Releated function

Hi ... I would like some advice regarding using the Related funciton.   I have two data sources joined by a created field in the one and a supplied field in the other. The first is my main data sou...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi MarcUrdang 

Since your model is many to many relationship, however the only join allowed is a many to many relationship.

So you could not use Releated function in many to many relationship.

Releated function is only work in one to one relationship or one to many relationship.

Since for table which is many, it has multiple value, releated only return one value, so it couldn't achieve.

For your case, you could use this formula

 

CalcName = MAXX ( RELATEDTABLE ( 'TableName' ), 'TableName'[FieldName] )

 

 

and here is a simple sample pbix file, you could try it and you will understand it well.

 

Regards,

Lin

  • MarcUrdang's avatar
    MarcUrdang
    Icon for Post Patron rankPost Patron
    6 years ago

    Hi again .. no there is still something wrong ... Can we try and Skype this? If not I will try and get someone else to help ... I need to fix this by tomorrow morning.

    thanks
    Marc

    • v-lili6-msft's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      hi  MarcUrdang 

      If possible, could you please share your sample pbix file and your expected output, that will be a great help.

       

      Regards,

      Lin