Display data using date slicer having multiple

[RUPSY777]

For a user given date range(single column)display data

Requirement:
starting before the start date and ending at the end date
starting before the start date and ending before the end date
starting after the start date and ending before the end date
starting after the start date and ending after the end date
starting and ending within the date range
starting and ending at the specified range

data available
A table contains the cols as(with other cols not relevant to the problem)
Start Date
End Date
Inventory item

[amitchandak · Accepted solution]

@RUPSY777 , With an independent date table

measure =
var _max = maxx(allselected('Date'), 'Date'[Date])
var _min = minx(allselected('Date'), 'Date'[Date])
return
calculate(count(Table[Inventory item]), filter(Table, Table[Start Date] >=Min && Table[End Date] = _max))

same way build others 

[v-easonf-msft · Accepted solution]

Hi, @RUPSY777 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Please share some sample data( in excel ) and expected result.It will help to provide the appropriate solution. 

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@RUPSY777 , With an independent date table

measure =
var _max = maxx(allselected('Date'), 'Date'[Date])
var _min = minx(allselected('Date'), 'Date'[Date])
return
calculate(count(Table[Inventory item]), filter(Table, Table[Start Date] >=Min && Table[End Date] = _max))

same way build others 

[RUPSY777]

Hi thank you for your response..

Can you refer to which date you are referring to in the below highlighted syntax?

var _max = maxx(allselected('Date'), 'Date'[Date])