Calculating Moving Average using Table calculations ?

Average using Table calculations

Calculating Moving Average using Table calculations?

Ans:
1. Drag Order Date into columns, and right click on that and select more option, then select the date part as MONTH/YEAR.
2. Drag Sales into Rows.
3. Create a parameter for Periods to Average. As shown below.

Parameter For Periods To Average

4. Create a calculation for Moving Average. As shown below.

Average using Table calculations
5. Drag the Moving Average calculation into Rows then right click on that field and select Add table calculation option and select the fields as shown below.

moving average calculation

6. Right click on the Moving Average at row level and select the Dual Axis.
7. The visualization looks like below.

Average using Table calculations

 

Leave a Reply

Your email address will not be published. Required fields are marked *