Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filtering based on Todays date

I have two coloumns in one of the tables of my data model : Start Date and End Date  I need to filter values based on the Condition that every time the user opens the report ,the date of opening the...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Create a measure like below and add it to filter.

    Measure = IF(SELECTEDVALUE('Table'[date])<=TODAY(),1,0)

    Result would be shown as below.

     

    Best Regards,

    Jay 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You to create a new column like this in date table and select as "Select" value

 

Switch( True () ,
[Date] >=min(Table[Start Date]) && [Date] >=max(Table[End Date]), "Select",
"UnSelected"
)

 

Also refer: https://www.youtube.com/watch?v=hfn05preQYA

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for the answer.Do I need to create a new date table which is only for dates or I can add this column in the exisiting table which has start and end date coloumns?