Forum Discussion
Average
Good day! Please help! How to calculate the average of % from 4 different tables?? Table 1 - KPI 1 - 100% Table 2 - KPI 2 - 100% Table 3 - KPI 3 - 100% Table 4 - KPI 4 - 78% In the E...
Average Percentage = (SUM('Table 1'[KPI 1]) + SUM('Table 2'[KPI 2]) + SUM('Table 3'[KPI 3]) + SUM('Table 4'[KPI 4])) / 4
Hi Anonymous
There are several ways for achieving this. One of them are:-
CombinedTable = UNION('Table 1', 'Table 2', 'Table 3', 'Table 4')
Then
AveragePercentage = AVERAGE(CombinedTable[KPI])
Thank you
Hope this will help you.
Hello! Thanks.
KPIs is measure.
Should I create the table? How?