Create summarized table using data from multiple tables

[lotus22]

I need to create summarize table using data from 3 tables. I need to get average score by Month, Year, and Division into summarized table.

1. Each division could have multiple scores in one month
2. I need to be able to add all Average scores for each year.
3. I need to be able to show monthly scores by Month, or division (add all average scores)

Table 1
Division	Year	Month	Score
Division1	2021	Jan	3
Division1	2021	Jan	4
Division1	2021	Feb	3
Division1	2021	Mar	4
Division1	2021	Mar	5
Division 2	2021	Jan	3
Division 2	2021	Jan	4
Table 2
Division	Year	Month	Score
Division1	2021	Jan	5
Division1	2021	Jan	4
Division1	2021	Feb	3
Division1	2021	Mar	4
Division1	2021	Mar	5
Division 2	2021	Jan	3
Division 2	2021	Jan	4
Division 3	2021	Jan	3
Table 3
Division	Year	Month	Score
Division1	2021	Jan	3
Division1	2021	Jan	4
Division1	2021	Feb	3
Division1	2021	Mar	4
Division1	2021	Mar	5
Division 2	2021	Jan	3
Division 2	2021	Jan	4
Division 3	2021	Jan	3

[amitchandak · Accepted solution]

@lotus22 , Append all tables in Power Query and then use Group By and Take Avg of Score. Or can Only Append and then take Avg measure in DAX. and you can use required columns in visual

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://docs.microsoft.com/en-us/power-query/group-by