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.
I don't know how to ask this in any different manner and there's clearly a miscommunication happening somewhere, so I will make one more effort to help in this instance then I will need to allow another member of the Community assist with this post:
Question: Which of the rows in your sample data meet the requirement you are wanting?
The expected response should list ID #152, #153..... #170...
Please tell me what you want the output to be based on your sample data.
Theo