Reveal Average from Date range with cumulative Data

[bw70316]

I have A Date of Original Placement and Ages that they were put in placement:

The data below is the Range of placement for children from 2/1/2019-2/28/2019. As you can see by the months, the dates come in several times because the same child has the same Date of Original Placement due to the fact that the data is cummulative. I am trying to extract the Average for Just February, but really dynamically so that I grab the first dates in the Date of Original Placement (in this case February) and spit out the Average Age of just those individuals. I would like to filter by month.

So in this case the Average of the Ages of the 7 Febs would be the value I'd like. 

AGE	Date of Original Placement	Month
5	2/7/2019	June
15	2/26/2019	June
5	2/7/2019	May
15	2/26/2019	May
5	2/7/2019	April
15	2/26/2019	April
15	2/26/2019	March
5	2/7/2019	July
10	2/6/2019	May
10	2/6/2019	April
10	2/6/2019	March
10	2/6/2019	July
10	2/6/2019	June
6	2/27/2019	July
9	2/27/2019	July
9	2/13/2019	July
6	2/27/2019	June
9	2/27/2019	June
9	2/13/2019	June
6	2/27/2019	May
9	2/27/2019	May
8	2/13/2019	May
6	2/27/2019	April
9	2/27/2019	April
8	2/13/2019	April
6	2/27/2019	March
9	2/27/2019	March
11	2/6/2019	March
8	2/13/2019	March
11	2/6/2019	July
11	2/6/2019	June
11	2/6/2019	May
11	2/6/2019	April
15	2/26/2019	July
5	2/7/2019	March
6	2/27/2019	February
9	2/27/2019	February
11	2/6/2019	February
5	2/7/2019	February
8	2/13/2019	February
15	2/26/2019	February
10	2/6/2019	February

[v-xuding-msft]

Hi @bw70316 ,

I am a little confused about your requirement. Do you want to calculate the average values of the first date per month? In your sample data, the first date is 2/6/2019.  I tried to create a sample you can reference.

Measure = 
var mi = MIN('Table'[Date of Original Placement])
return
CALCULATE(AVERAGE('Table'[AGE]),FILTER('Table','Table'[Date of Original Placement] = mi))

Is this what you want? If not, can you please post the expected result?

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bw70316]

I am trying to achieve February's dates as the only dates of entry. Those other dates are a result of new data coming in. Some of the kids are repeated, others exit or enter. Below is the data I want to grab, but I want it dynamically so that for whatever average age is for that month's dates of original placement appears.