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,

You may download my PBI file from here.

Hope this helps.

  • mpmsltd's avatar
    mpmsltd
    Helper I
    6 years ago

    Thanks Ashish_Mathur  but this is not what I need. 

     

    What I need is the daily occupancy average - which is a calculation of: customers that were staying on that day + customers that arrived on that day - customers that left on that day

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      You are welcome.  Show me your exact expected result.

      • mpmsltd's avatar
        mpmsltd
        Helper I
        6 years ago

        hi Ash in yellow is my expected result, the daily occupancy by day. Plus I'd like to be able to see the daily average occupancy in a month as well. The column "counted on dates" shows which dates the id is being counted as occupant.


        Please let me know if any questions. Thanks