Forum Discussion
DAX to create a date filter
Hello,
Can anyone help me with creating a date filter to include all dates in the range of past 6 months and next 6 months relative to today's date..assuming date_dt is the date field
6 Replies
- nandukrishnavs
Community Champion
Anonymous
Try something like this
Measure = CALCULATE(SUM(MyTable[Sales]),FILTER(ALL(MyTable[date_dt]),MyTable[date_dt]>=TODAY()-180 || MyTable[date_dt]<= TODAY()+180))
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂 - amitchandak
Super User
Anonymous ,
Measure =
var _min = date(year(today()),month(today())-6,day(today())) /// or date(year(today()),month(today())-6,1)
var _max = date(year(today()),month(today())+6,day(today())) /// eomonth(date(year(today()),month(today())+6,day(today())),0)
return
calculate([measure],filter(All(DATE), Date[Date] >=_min && Date[Date] <=_max)) 
daxCommunity Support
Hi Anonymous ,
You could refer to amitchandak ' suggestions, or you also could try to +/-180 days like below
Measure = CALCULATE(SUM(t2[amount]), FILTER(t2, t2[date]<=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())+180)&& t2[date]>=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())-180)))Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
