Forum Discussion
Solved
Moving Average
Hello all, I'm new to Power BI and have a query on some data analysis I'd like to perform. Any help would be much appreciated: I have a table of sales data which details sales at item level. ...
HI,@ORS1237
You can try to use built-in function of Power Query to create a pivot table
you can also use DAX to add a calculate Moving Average measure
Reference:https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
Best Regards,
Lin
v-lili6-msft
Community Support
Community SupportHI,@ORS1237
You can try to use built-in function of Power Query to create a pivot table
you can also use DAX to add a calculate Moving Average measure
Reference:https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
Best Regards,
Lin
Thanks you for your help Lin.
ORS1237
