Forum Discussion
Display data using date slicer having multiple
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
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
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
3 Replies
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
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])
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
