Is it possible to get the date range in a date slicer?

[asdfasdf3321g]

I need to generate a downtime report for devices.  I have a database of support tickets.  If a device is down, I have a ticket which includes the date of the problem and the number of hours of downtime.

The calculation would look something like this...

Sum of Downtime / DATEDIFF(MinDate, MaxDate, HOUR) = downtime percentage

I posted this question a while back and got this answer...

https://community.powerbi.com/t5/Desktop/How-can-I-perform-a-calculation-based-on-the-dates-in-a-dat...

The problem with this solution is that it looks at the records filtered by the date slicer, rather than the date slicer itself.  If I select January 1 - January 31 in the slicer, the earliest ticket might be January 10 and the latest ticket might be January 20, then the datediff is calculated based on the ticket dates rather than the date selected in the slicer.

Is there a way to get the values selected in the slicer?

[MFelix]

Hi @asdfasdf3321g ,

Use the following code:

Measure = DATEDIFF(min(Table[Date]);MAX(Table[Date]);HOUR)

[amitchandak]

@asdfasdf3321g , Can you share sample data and sample output?

You can refer my blog for date diff: https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

[Greg_Deckler]

Also, VALUES('Calendar'[Date]) should get you all of the values in a single column table.

[Greg_Deckler · Accepted solution]

If you have a Calendar table that is what your slicer is based on, then you should be able to do this:

Diff =
VAR __Max = MAX('Calendar'[Date])
VAR __Min = MIN('Calendar'[Date])
...

[asdfasdf3321g]

I had to look up a "calendar table" but that worked, thanks for pointing me in the right direction.