Forum Discussion
Solved
Occup%
Dear All, I am working on calcuating occupancy % for a property portfolio (dummy) consiting of 2 buildings (total 6 units). This % can be at portfolio level or for each builing (using slicers). I...
see attached for a modified version
Dear Ibendlin,
Oops, we are not getting what we are loooking for.
Step 1 - get total no of days available for a unit, aggregate this data at bldg level
Step 2 - get total no of days occupied for a unit, aggregate this data at bldg level
Step 3 - Units occupied/units avaiable - % occupanyc at bldg level
this is what DAX has provdied.
This is for 2022 (Jan to Dec)
Thansk for your efforts.
see attached for a modified version
Million thanks for a perfect solution.