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.

mpmsltd's avatar
mpmsltd
Helper I
6 years ago

Hi Ashish_Mathur  wow! Sorry about that I was searching for a crazy measure or calculated column without going to the Edit Query mode, but it seems that your solution is more simple and efficient! According to my tests it's working with my data, thank you so much.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

You are welcome.