DAX to create a date filter

[Anonymous]

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

[dax]

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 Zhi

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

[Anonymous]

Thanks Zoe Zhi

[amitchandak]

@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))

[Anonymous]

Thanks Amit

[nandukrishnavs]

@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 🙂

[Anonymous]

Thanks Nandu