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 

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