Forum Discussion

mpmsltd's avatar
mpmsltd
Helper I
6 years ago
Solved

Daily Occupancy Average

Hi everybody,   I have a table that shows the Start Date, End Date and Customer ID. What I want to do is to see the daily occupancy average per period of time (year for example and be able to drill...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my solution file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello All,

 

Thanks for your replies. Ashish_Mathur ´s solution has helped us a lot. 

 

Now, we want to take it to the next level and evaluate this measure for a MONTH scale or even within a YEARLY basis. 

 

This is not being possible since the total OCCUPIED ROOMS are not a sum of the occupied rooms for every night. I believe this was also the case for posted solution, since the total does not match up with the correct sum for the period of nights shown. 

 

Any ideas how we can manage this? 

 

In case you need to see toher tables from our model, let me know. 

 

Thanks in advance!!

Santiago Sanchez 

 

 

P.S: In our model, every reservation code has a defined number of occupied rooms (the values are calculated also using a TABLE created within POWERQUERY ). 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Share the link from where i can download your PBI file and show the expected result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      First of all, thank you all for helping us. 

       

      THis is the link where you can download the pbix. file:

      https://1drv.ms/u/s!AtEu70FghQZohcZeLVDKCRAsVeh3Xg?e=WbXSad  

       

      Now, there you will see my comments and the expected results there. 

       

      We are having trouble since the total values for the measure is not computing the sum of rooms occupied per night. So no clue on getting a monthly avarage occupancy rate...

       

      Thanks so much. 

       

      Santiago Sanchez

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        I do not understand anything in that file.  First the language is not English.  Second, how do you say that the answer should be 49?????  There are just way too many visuals there.  Delete the ones that are not required so that i know what i have to focus on.