Average summarize table

[MSCHATZ]

Hi everyone, i have a question,

I use power querry to summarize my result by average and by week, but when i look to my table the result did not match.

Here my example 

The result I want

The result I get by using power querry group by 

What can i do to fix it ?

Thanks for the time.

[v-yanjiang-msft]

Hi @MSCHATZ ，

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @MSCHATZ ,

According to your description, I create a sample the same with yours.

Here's my steps:

Select SUBCATEGORY, ZONE, and POS columns at the same time, the click Group By. In the Operation option select Average, in the Column option select Flooring column.

Then get the correct result.

Not sure why you have the different result with me, I attach my sample below for your reference, you can open it to see the difference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.