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

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.