Forum Discussion
Remove a entry in PowerBi based on next entry
lotus22 I am pretty sure that's the logic applied in tblRemoved? If not, can you do me a favour and highlight the exact output you want based on the rows you have in the sample data?
Yes, lotus22. I understand that. That is what I did already in the 'tblRemoved' table for you in the PBIX file I attached earlier. If this isn't the output you want, can you please tell me which rows are the output you want based on your sample data.
We only need to remove late entries where subsequent for the same Machine and Operator are within 5 minutes.
We look for first late entry, capture machine and operator. Look for similar entry with same Machine and Operator in next 5 minutes. If there is nothing then we register the late entry.
If there is entry within 5 minutes, then we remove the late entry.
The goal is that operator has fixed the late entry in 5 minutes or less.
