change table structure with measure

[ktt777]

hi All, 

How can i change structure of the table and add measured column.

Here is the original table : 

i want to create a table as below : 

Here is the link to the power bi file : https://1drv.ms/u/s!ApIDnMK2eKiFgR2WPdMwZSRWVJhH?e=MgCVqO

thank you

[amitchandak · Accepted solution]

@ktt777 , unpivot the table in power query

https://radacad.com/pivot-and-unpivot-with-power-bi

You can do Avg in visual or during unpivot