Disclaimer: New to Power BI and learning is still in progress.
My Team and I are working on some date to filter the schedule of employees. We are checking the log out date of the employees. But we are getting multiple dates so what we did is we tried to filter it using time difference between attendance and the scheduled date. Please see below sample.
We are getting some problems on the out_is_valid column. It should only return "1" on the same schedule date as the in_is_valid column which are highlighted in green. But we are getting another "1" value which is in blue highlight. How can we only select the IN and OUT date with the same sched start and end? Below is our code.