Forum Discussion
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. ...
Greg_Deckler
Community Champion
Community ChampionCarmenSme 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]))