Trick 020 Calculate the average price of a product under multiple conditions with power query

 In the process of working with Excel sometimes we also need to calculate the average value of the data. This is easily done with the AVERAGE or AVERAGEIFS command in Excel.

But the problem is that we have to calculate the average value with many different conditions. This is hard to do with the simple AVERAGE or AVERAGEIFS function in Excel.

 In Excel, there is an additional Power Query application. With the power and convenience of Power Query, calculating the average value of the data according to the initial conditions is done easily.