cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ORS1237 Frequent Visitor
Frequent Visitor

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. Two of the columns are 'date' and 'item category'. My objective if to identify when particular customers aren't buying a particluar item category by identifying the moving average of monthly sales by category, and looking at customers whose current month's sales (by category) are below this moving average.

 

Acheiving this resutl in excel required creating a pivot table so summarise sales per month and then calculating a moving average of the resuls. I'm unsure how I would go about this in Power BI desktop.

 

Thanks,

 

Oliver

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Moving Average

HI,@ORS1237

      You can try to use built-in function of Power Query to create a pivot table 

1.PNG

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

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

Re: Moving Average

HI,@ORS1237

      You can try to use built-in function of Power Query to create a pivot table 

1.PNG

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

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

Re: Moving Average

Thanks you for your help Lin.

 

ORS1237