How many records were active on a given day

[Anonymous]

I am a fairly new PowerBI user who is mostly learning as I go along.

I have data that basically looks like this:

Resident              Move in date                     Move out date

A                             1/1/19                                   10/18/19

B                             5/1/16                                   8/30/20

C                             1/1/20                                   No end date

For any month I want to be able to say how many people lived in the building. In November 2019 1 person lived there. In Febraury 2019 2 people lived there, and so on.

I have tried searching for an answer, but I can't seem to find anything that fits, or else I'm not understanding what I'm reading. Any help would be greatly appreciated!

Thanks.

[amitchandak · Accepted solution]

@Anonymous , refer if this blog can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

Thank you so much @amitchandak ! I knew that there had to be something out there, but clearly my google-fu was lacking. I will be able to easily apply this to my dataset.