Rolling Measure

Rolling measure type is used to show an average or total value of some measure in a certain time period.

For example, you can create a measure that will show an average profit for the last three month. To do that, create a new calculated measure of “Rolling” type:

In the next window fill in the fields as it is shown in the picture:

The Operation type selected at the bottom (Average) means that the average value of a measure, set in the “Base Measure’ field, will be calculated, in our case – “Gross Profit”. Values in fields “Periods” and “Time Hierarchy” state that the average should be calculated over the last 3 month in the “Date.Calendar” hierarchy.

After filling in the fields press «OK» and you will see a new measure in a measures list:

To try that new measure in practice, create a new page of the structure, described below.

Put months of 2017 on columns:

Put two measures on rows: “Gross Profit” and “Gross Profit Rolling”.

Next, add a chart to the page and change the chart properties like this:

You will get a page looking like this:

Profit for a current month is displayed with a red line, and the blue line shows the average profit for the last three consecutive months. As you can notice, the line corresponding to the calculated measure is more flat, it doesn’t display the sharp rises and falls of profit. It looks more like a tendency, because the average value of profit in three months is taken into account.