Excel - Get & Transform (Power Query) - Moving average on M Code - Help on how to do it

[Anonymous]

Hi, All

I am trying to do a moving average on Excel Get and Transform, but I can't make it work.

Here is an example of the data.

item, month have a particular value; each item has multiple months.

The goal would  be to use some group by item and calculate moving average (say 3 months) per item.

I tried added an index and do {index}-1 thing, but I can't make it to work given the groupby contraint. I am looking for M code solution as I am doing some clean up.

Thanks for lending a hand here! 🙂 let me know any questions. Thanks!

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

You could follow this article

Grouped running total in Power Query

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.