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

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.

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