How to group the table to get the desired result?

[Anonymous]

Hey! 

Suppose in the Power Query Editor, I have the following table named Table:

And now from the given table, I want to construct the following table:

How can I reach this?

The solutions says:

"Group by [Department] and [School] and create a new column named [Avg Score] that uses the AVERAGE function on the [Score] column."

I tried

TableNew = CALCULATETABLE(SUMMARIZE(Table,Table[Department],Table[School],"Avg Score", AVERAGE(Table[Score])),Table[School]="School1")

and it works. 

Maybe this is meant, maybe this is not meant, I do not know.

[lbendlin]

yes, looks ok. Could have used AVERAGEX too.