Forum Discussion
Custom Filter for Due Dates
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
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)
2 Replies
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)