DAX formation for date

kodnil2020 ,

Try in a new column

Hi, kodnil2020 

Based on your description, I assume that you want to filter out employees whose start date is less than or equal to31 Jan of current year. I created data to reproduce your scenario. The pbix file is attached in the end.

Employee Details:

You may create a measure as below.

Visual Control = 
IF(
   SELECTEDVALUE('Employee Details'[Start Date])<=DATE(YEAR(TODAY()),1,31),
   1,0
)

Then you need to put the measure in the visual level filter to get the result.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.