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

Shreyas Kale 61 Reputation points
2022-05-08T09:55:39.923+00:00

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.
199918-capture.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,540 questions
0 comments No comments
{count} votes