Forum Discussion

lucpaymetals's avatar
lucpaymetals
Frequent Visitor
3 years ago

Current Day slider button

Hello,

I need a button that if you click on it, it will filter everything by the current day. I need to put this in a slicer so i can filter everything by it. 

Does anyone know how todo this.

Currentday = IF(DAY(TODAY())=DAY(ValueEntries[Document_Date].[Date]),1,0)

This is what I have but it does not seem to work.

Thank you.

General Comment
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • marcelsmaglhaes's avatar
    marcelsmaglhaes
    Super User
    3 years ago

    Hey lucpaymetals 

     

    You need create a COLUMN in your table, and not a measure. 


    Current Day = IF(ValueEntries[Document_Date] = TODAY(), 1,0)
     
    If this post helps, please mark as solved to help other users find quickly in our community!

    Regards,
    Marcel