How to set up a Future Date Filter
I'm trying to figure out how to set up a beast mode that will allow me to filter out historical dates while keeping the Date Range open to Current FY. I feel like I almost had it with the below calculation, but it's cutting off anything that is scheduled after this current week time period in future months:
case when year(current_date) <= year(`Target Date`) and week(CURRENT_DATE) <= week(`Target Date`) then 'Future' else 'Historical' end
I tried to replace 'week' with 'day' and then I'm only getting the last couple of days of the month.
Essentially, if I wanted it to work properly, I need it to show me data for every day after today, until the end of our fiscal year.
Not sure what I'm doing wrong, probably something obvious I'm just overlooking, but any help is appreciated!