Counting number of occurrences in a year/period

[BM4291]

Hi,

I have is a list of people and a start/end date for them on a table, it looks a little like the below, people can appear on the table multiple times and date periods can overlap: 

What I need to be able to do is say how many people were around in a given period i.e. financial year (1st Apr -  31st Mar). Given the above if I were to do a count of people for 2015-16 I would expect to see 3, if I did a count for 2016-17 I would expect to see 1.

My base measure is: people = DISTINCTCOUNT(Table[ID]).

It feels like there should be an easy way to do this with a DATESBETWEEN or FILTER but I keep missing it; the 'Start' column is currently in a relationship (one-way) with my Dates table but this is then only counting people in the year that they start so Joe Bloggs in the above would only count in 2015-16 when he should also be counted in 2016-17.

Hopefully the above makes sense, I have a feeling I need to delete the relationship and try something else with the start and end points of the financial years?

[v-piga-msft · Accepted solution]

Hi @BM4291,

You could refer to this similar thread which should help you.

Best  Regards,

Cherry

[BM4291]

Thanks, this is along the lines of what I was trying to get at... I think I was just a bit tired towards the end of a Friday in the office and was missing the obvious!!

Really helpful links, will share with my team.