Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating Average from different table

Hi everyone, hope you doing well.  May I know how can i calculate average value from a different table ? below are the example.  In table 1, i would like to calculate the average amount from table ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )
DimaMD's avatar
DimaMD
Solution Sage
4 years ago

Hi Anonymous  Use the same measure I gave you earlier

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, DimaMD , 

    Thanks for replying, i have tried but not sure why it could not generate my expected result. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi DimaMD , would also like to clarify that. I wanted to create a new column in the table 1 that store the average value from table 2