Dynamically show Average of Cumulative Data Based on Unique/Initial Dates

[bw70316]

In my first photo I demonstrate the filters I have in the majority of my project. As you can see, it is culminating the entire average age for the entirety of the data. My goal is to display the data from the second picture, the average age of children INITIALLY entering the system. However, I want my Date of Original Placement to appear Dynamically for each month and to only count the datapoints currently seen in the filter, which are the initial dates of placement. My data is also cummulative with, for example the dates for FY19 March, appearing again in April FY19, May FY19, etc. due to the way the data is collected. My relationship between my tables is with another date in my table.

[bw70316]

Here is an example of my data, unfortunately I could not include the age itself. I have a filter on the Month of September. As you can see, it is giving me the average age of all children who are in care in September. What I am trying to achieve, is the average age of the dates of those INITIALLY entering the program (the dates highlighted in the second picture). I also want it dynamically, so that when I choose ANY month I receive the average age of the children who just entered the program. 

[bw70316]

Here is a snippet of the data. Imagine there are children who have come through the system and entered in past years. This is the list of children who are in the system in September. The filtered list at the bottom is the date 4 NEW CHILDREN entered the system. The Month works as a separator for the data so that I know this list of children is September's list, IT DOES NOT MEAN THE CHILDREN ENTERED INTO THE SYSTEM THIS MONTH NECESSARILY, ONLY THE FOUR AT THE BOTTOM DID. I WANT TO CAPTURE THE AVERAGE OF THOSE AGES FOR EVERY CHILD WHO ENTERS THE SYSTEM IN A GIVEN MONTH:

AGE	Date of Original Placement	Month
3	8/31/2017	September
6	8/31/2017	September
9	9/26/2017	September
8	12/8/2015	September
6	12/8/2016	September
18	4/10/2018	September
17	3/4/2016	September
1	7/18/2018	September
17	9/21/2018	September
2	8/23/2018	September
1	7/11/2018	September
8	9/21/2018	September
4	7/13/2018	September
5	8/8/2018	September
15	8/8/2018	September
18	8/9/2018	September
6	10/1/2018	September
9	10/1/2018	September
1	7/5/2018	September
3	8/27/2018	September
19	2/25/2018	September
19	5/11/2018	September
19	1/7/2018	September
20	5/1/2018	September
18	8/7/2018	September
19	11/26/2017	September
0	5/1/2018	September
21	2/27/2017	September
19	8/1/2018	September
21	4/6/2017	September
18	7/8/2018	September
19	3/1/2018	September
18	7/3/2018	September
18	7/3/2018	September
18	8/1/2018	September
18	8/30/2018	September
21	2/21/2017	September
19	10/10/2017	September
19	5/25/2018	September
Avg: 13

Here is the data of original placement filtered so that the dates of original placement that occurred in Septmeber are shown only (I realize some dates bleed into October, that is by design). I want the dates of original placement to be filtered in such a way that they spit out THAT MONTH's average age:

AGE	Date of Original Placement	Month
17	9/21/2018	September
8	9/21/2018	September
6	10/1/2018	September
9	10/1/2018	September
Avg: 10

[parry2k]

@bw70316 I'm not sure how to interpret this screen shot, you need to send data in excel and expected result. if you can share pbix with sample data that is even better. Remove any sensitive information before sharing.

[parry2k]

@bw70316 can you share sample data and expected result. Your post is not very clear.