Forum Discussion

Randcharles's avatar
Randcharles
Icon for Helper I rankHelper I
2 years ago

DAX _ Calculate occupancy rate

Hi all,  I have a report where I need to calculate occupancy rate : office reservation/ available desk. When I need to compute the global occupancy rate for a  month or a week , it shows a wrong ...
Need Help
Randcharles's avatar
Randcharles
Icon for Helper I rankHelper I
2 years ago

Hi bhanu_gautam ,

Thank you for help.
But it seems that it doesn't fit with my need. 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Randcharles ,

 

Your calculation is based on your data model and your tables. Please share a sample file with us.

We need to know how to calculate Number of reservation and Available desk.

You can also show us the result you want, this will make it easier to find the solution.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.