Creating a dynamic date filter for the current day

Hi, Anonymous ;

You could create a flag measure.

flag = 
var _max=CALCULATE(MAX('data'[date]),ALL('data'))
var _year= IF(MAX('FilterYear_Table'[Disp Year])="Today’s Year",YEAR(_max), CONVERT(MAX('FilterYear_Table'[Disp Year]),INTEGER))
var _month= IF(MAX('FilterMonth_Table'[Disp Month])="Today’s Month",MONTH(_max),MONTH(  MAX('FilterMonth_Table'[Disp Month]) & " 1"))
var _day= IF(MAX('FilterDay_Table'[Disp Day])="Today’s Day",DAY(_max),CONVERT(MAX('FilterDay_Table'[Disp Day]),INTEGER))
return IF(MAX([date])<=DATE(_year,_month,_day),1,0)

Then apply it into filter.

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.