Occupancy overview - planning students

[CarmenSme]

Hello, 

I'm quite new to PowerBI (have done a training a year ago, but somehow most of the info slipped my mind while I tried to do te following) and I hope someone can help me with my question. 

I work with a company where we plan students for an internship. For that, the different departments let us know how many places they have for the intern, after which we put this in the system. In this system school can see these places an can first reserve a spot for a future student and later on 'match' a student name on this reservation. This is all visible in the planbord, which is nice! However, the system doesn't yet give a dashboard/overview of the amounts that we have planned based on this. Therefore I would like to make this (temporarily). And my question has to do with the data below (I translated the columns, sorry for possible typo's):

Title	From	Until	Amount of places	Reserved places	Matched places
Internship year 2	08-02-2023	07-07-2023	3	0	0
Internship year 3	06-02-2023	14-04-2023	2	0	0
Internship year 4	05-06-2023	07-07-2023	2	0	0
Etc.	08-02-2023	07-07-2023	2	0	0
Etc.	28-11-2022	09-12-2022	2	0	0
Etc.	07-09-2022	14-04-2023	3	3	3

What the planners would like to have is an overview of how many available/reserverd/machted places at certain point in time. Sort of the occupancy at a certain point. For example how many places do we have available in the month october or on a particular day or week. 

Can anybody maybe help me with how I can do this?

Thanks a lot in advance!

[Greg_Deckler]

@CarmenSme Perhaps something like:

Measure Amount of Places =
  VAR __Date = MAX('Dates'[Date])
  VAR __Year = MAXX(FILTER('Table', __Date >= [From] && __Date <= [Until]),[Title])
RETURN
  IF( __Year = BLANK(), BLANK(), MAXX(FILTER('Table',[Title] = __Year),[Amount of places]))