Centered 3 months average (measure)

• Type: Inserted as a measure
• Description: Calculates the average of 3 months' intervals - from 1 month before to 1 month after any month, in each column.
• Range:
  • Columns: Each column
  • Rows: 3 rows intervals
  • Measures: First measure
• Syntax:

avg(0, -1:1, m1)

• Sample crosstab:

Example

Adding the 3 months rolling average, the table will now look like this:

NOTICE: 
The first month and the last month will not be correct, since it won't include full 3 months in the average. 
If you want to adress this, you can add a visiblity agent, that hides the 3 months rolling average value with this syntax:
count(d1,d1:0,m2)<2 or count(d1,d-1:0,m2)<2

Choose properties, visibility agents

Pick Hide Value

Pick 3 months rolling average

Add the condition shown above:

Now your table looks like this (hiding the incorrect values)