Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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 |
Solved! Go to 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
@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
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |