Calculating Number Of Days Between Two Selected Dates

[Anonymous]

Hi Everyone, 

Does anyone know how to do the following: 

1. Calculate the number of days between two dates, based on slicer selection. The slicer has to be the 'Between' one where you need to input two dates. 

2. Then based on the number of days, perform a count of how many sales were made between and including those dates. 

Because the date has to be a range, i have no idea how this works. Does 'SelectedValue' still make sense?

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous , Try a new measure like

diff =
var _min =minx(allselected(date),date[date])
var _max =maxx(allselected(date),date[date])
return
return datediff(_min,_max,day)

[Anonymous]

Thanks so much @amitchandak 

Worked perfectly!