Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Retrieving Data based on two dates in one table

Hi,  Good day. I have a table with two dates (activated date and reactivated date) and the requirement is to retrieve the data based on that two dates using only 1 calendar. Here's the sample tabl...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , with help from an independent date table for slicer

 

Started in range and end after Range =
var _max = minx(allselected(Date), Date[Date])
var _min = maxx(allselected(Date), Date[Date])
return
calculate(count(Table[Project Number]), Filter(Table,(Table[CreatedDate] <=_max && Table[CreatedDate]) >=_min ) )