Set filter in PowerBI for SQL Query data to see only today's recent events for unique UserID in table

Question

Hello, I am preparing PowerBI dashboard using SQL database of attendance machines to show employees count on office floor's. So currently whenever I refresh dashboard, It shows all the entries including past date events for all employees (As shown in attached image). Instead of that I just wanted to see today's events (from 12:00 AM to 11:59 PM) and only last recent event for that unique UserID.
Can you please help me what logic can be applied in PowerBI to apply these filters.