I have a report where I am changing the various views of the data by using a timeslicer. The dataset is a table of meeting information - starttime, endtime etc. from which I calculate utilization, length etc. If I have a meeting that lasts 12 hours each day, when I calculate utilization of the room (as a percentage over a 12 hour period) it should always be 100%. Hwoever, when the the timeslicer selects 2 or more days, the utilization is multiplied by the number of days - so 2 days where the meeting lasted 12 hours would report as 200% usage whereas what I want is it to report 100% usage over those 2 days. To do this, I need to get a variable which holds the number of days in the period selected by the timeslicer so I can divide the utilization % by the number of days. How do I do this? i.e. how to programiatically (in DAX) get the daterange selected by the time slicer?
This data is pulled from SQL and the report is setup as an import report.
