Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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)

amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

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