Hi Sam,

I have been playing around with this measure to try and see if I can get it working.

It is definitely the root of the problem.

I isolated just the part that calculated the number of entrants to test and attempted to add the date range in.

```
Number of entrants test =
// Calculate timeframe for entrants. Previous year backdated by number of years selected
VAR MinYear = CALCULATE( MIN(Dates[Year]), ALLSELECTED(Dates) )
VAR StartYear = MinYear - [Back Year Selection]
VAR FinishYear = CALCULATE( MAX(Dates[Year]), ALLSELECTED(Dates) ) - 1
VAR DateRange =
FILTER(
ALL(Dates),
Dates[Year] >= StartYear && Dates[Year] <= FinishYear
)
// Calculate the number of entrants in the given period
VAR NumberOfEntrants =
CALCULATE(
COUNT('Average Entrance'[ID]),
DateRange
)
RETURN
NumberOfEntrants
```

The result was a table of the end of year results, not the selected month (eg march).

I modified it to include the selected month.

```
Number of entrants test =
// Calculate timeframe for entrants. Previous year backdated by number of years selected
VAR MinYear = CALCULATE( MIN(Dates[Year]), ALLSELECTED(Dates) )
VAR StartYear = MinYear - [Back Year Selection]
VAR FinishYear = CALCULATE( MAX(Dates[Year]), ALLSELECTED(Dates) ) - 1
VAR FinishMonth = SELECTEDVALUE(Dates[Month Of Year])
VAR DateRange =
FILTER(
ALL(Dates),
Dates[Year] >= StartYear && Dates[Year] <= FinishYear && Dates[Month Of Year] <= FinishMonth
)
// Calculate the number of entrants in the given period
VAR NumberOfEntrants =
CALCULATE(
COUNT('Average Entrance'[ID]),
DateRange
)
RETURN
NumberOfEntrants
```

The theory behind this is that I would not need to calculate beyond the same month the previous year to get me valid results.

The results were closer, but not quite right.

They should look like this

but look like this

Once I get that bedded down, then I will be able to move onto the averages and cumulative averages.

Thanks

Fun.pbix (931.4 KB)