Custom Filter for Due Dates

[Anonymous]

Hello,

I have a report with a Due Date on it. Is it possible to create a filter that will show only the dates before and including today and 2 weeks after today only?

Thank you in advance 

[amitchandak · Accepted solution]

@Anonymous , You can create a column or measure

measure  =

calculate(Sum(table[Value]), filter(Table, Table[Due Date] >= Today()  && Table[Due Date] <= (Today() +14 ) ) )

Flag Column = // you can use in the filter

if( Table[Due Date] >= Today()  && Table[Due Date] <= Today() +14 ,1, 0)

[Anonymous]

Thanks a lot.

And what if I would like include the dates that are 30 days before today as well (I mean as an addition to the function you suggested)?