Hello experts of Power BI,
I have a table that has three columns, one is the name of the person, one is the date they entered and the last column is the date they left. I am trying to create a new table or measure on Power BI that calculates the occupancy for each patient per month. For example, my original table looks something like this:
http://www.screencast.com/t/s5iugCYKqQ8n

The table or measure I am trying to create would look something like this: http://www.screencast.com/t/tGNGibLh145


Can someone please help me figure out how I can accomplish this? I have been researching and trying different things on Power BI to do this, but I am lost. I would highly appreciate if anybody can help me figure it out, I will compensate with coffee via PM to anyone who can guide me to the right way. Thank you!