Trailing 12 months average (as a measure)

• Type: Inserted as a measure
• Description: Calculates the average of 12 months' intervals - from any month (included) and 11 months back in time, in each column.
• Range:
  • Columns: Each column
  • Rows: 12 rows intervals
  • Measures: First measure
• Syntax:

avg(0, -11:0, m1)

• Sample crosstab:

Example

Adding the 12 months rolling average (as a measure), the table will now look like this:

NOTICE: 
The first 11 months the 12 months rolling average will not be correct, since it won't include full 12 months. 
If you want to adress this, you can add a visiblity agent, that hides the 12 months rolling average value with this syntax:
count(c1,d1:0,m1)<12

Choose properties, visibility agents

Pick Hide Value

Pick the 12 months rolling average

Add the syntax shown as condition