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

In the sample file that you uploaded it does not have a start and end date, there's only one date on the Data table. Please check, my example has two different columns, start and end date.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

I have treated 3 columns as inputs and have then run a transformation to convert the 2 date columns into a single date column.  This was done to create a single date slicer.

  • 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.