Calculating Moving Average using Table calculations?
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.
4. Create a calculation for Moving Average. As shown below.
6. Right click on the Moving Average at row level and select the Dual Axis.
7. The visualization looks like below.