Forum Discussion

CarmenSme's avatar
CarmenSme
New Member
3 years ago

Occupancy overview - planning students

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):

TitleFromUntilAmount of placesReserved placesMatched places
Internship year 2      08-02-2023      07-07-2023      300
Internship year 3      06-02-2023      14-04-2023      200
Internship year 4      05-06-2023      07-07-2023      200
Etc.      08-02-2023      07-07-2023      200
Etc.      28-11-2022      09-12-2022      200
Etc.      07-09-2022      14-04-2023      333

 

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!

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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]))