Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Use [Today] in filters

Hello all   I’ve built a report which should be filtered in two ways. StatusActiveOn should be every date less or equal today StatusDeadOn should be every date greater than today   So far i add...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,


    I make a test using the following sample table.


    I created a calculated column and drag it to page level filter, everything works well. Could you please share sample data of your table so that I can test?

    chkdate = IF(Table1[Date]<=TODAY(),1,0)



    Regards,
    Lydia

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous Please try to have "Relative" date filters on the Slicer. That should work for you !!