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] )