Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 2 based on the supplier ID.
Result expecting is
Solved! Go to Solution.
@Anonymous
Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )
@Anonymous
Any relationship between tables?
yes
@Anonymous
Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )
Hi !!!! thank you so much !!!! thanks for the answer !
Hi @Anonymous Use the same measure I gave you earlier
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
Hi, @DimaMD ,
Thanks for replying, i have tried but not sure why it could not generate my expected result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |