Forum Discussion

oren's avatar
oren
Helper III
3 years ago

Add filter for ranges

Hi   I have a member database with three columns: one for account ID, one for 'from date' (the start date of the membership), and one for 'end date' (the end date of the membership). Is there an o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi oren ,

 

Here I create a sample to have a test.

I suggest you to create a Calendar table to help calculation.

Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]),"Month",FORMAT([Date],"MMMM"),"MonthSort",MONTH([Date]))

Measure:

Filter to show all active members = 
VAR _RANGESTART = MIN('Calendar'[Date])
VAR _RANGEEND = MAX('Calendar'[Date])
RETURN
IF(MAX('Table'[Start Date])<=_RANGEEND && MAX('Table'[End Date])>=_RANGESTART,1,0)

Add this measure into your visual and set it to show items when value = 1. Result is as below.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.