SELECT VALID DATE USING POWER BI DAX

[ZZZZZZZ37]

Hi Power BI Community, 

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.

Thanks for your help.

[amitchandak]

@ZZZZZZZ37 , Based on what I got

new column =

var _max = maxx(filter(Table, [User] = earlier([User]) && [Schedule Date] = earlier([Schedule Date]) && && [Schedule Start Time] = earlier([Schedule Start Time])  && && [Schedule End Time] = earlier([Schedule End Time]) && [Case] = "Out") ,  [attendance out])

var _count= maxx(filter(Table, [User] = earlier([User]) && [Schedule Date] = earlier([Schedule Date]) && && [Schedule Start Time] = earlier([Schedule Start Time])  && && [Schedule End Time] = earlier([Schedule End Time]) && [Case] = "in") ,  [attendance out])

return

if(not(isblank(_cnt) )  && _max = [attendance out], 1, 0 )

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ZZZZZZZ37]

Hi @amitchandak , 

Thanks for your reply. I tried the code that you sent but I didn't quite get it. Please see attached pbix. You may refer on the trial_out column.

https://drive.google.com/file/d/1bUfmHrrm957mEdh4-utKOrFqfIdlPQ2Y/view?usp=sharing

Regards,