Forum Discussion
Daily Occupancy Average
Ashish_Mathur sorry but again you are just counting the number of ids, this is not what I'm looking for. Please see my example previously showing my expected result, it considers the start and end date to define the daily occupancy.
Hi,
That is exactly what I am doing. My answers matches what you have shown in the yeloow highlighted section of your previous message.
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.
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.
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.
You are welcome.