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.

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I apologize for the inconvenience Ashish_Mathur. This is the new file, where I give more detailed information and eliminate what is not necessary to understand the system and the measures I'm trying to apply.

       

      https://1drv.ms/u/s!AoHoPnkGYJRRb5miDOfd3QT_q94?e=58YbIg

       

      Thanks for your kind support

       

      Santiago Sanchez

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        Hi,

        You may download my PBI file from here.

        Hope this helps.