Forum Discussion
Remove a entry in PowerBi based on next entry
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
TheoC Thank you and sorry for the confusion. I simplified the data little bit and revert back to raw data. In Raw, we have item requested from Operator. If it is requested then there should be response back. The response can come from operator or the supervisor. But there has to be response for that machine. If the response doesn't come in 5 mins then we mark it "LATE". If it does come back in 5 minutes, then we mark it "DELETE"
I have added Mark Column and also the comments. hope this helps Please see attached
| Id | Created | CreatedBy | Modified | ModifiedBy | Deleted | State | Machine | Custom | Shift | Mark | |
| 159 | 8/29/2024 9:15 | 10314 | FALSE | 1 | RW100 Side A | Pass | 1 | ||||
| 158 | 8/29/2024 9:15 | 10314 | FALSE | 2 | RW100 Side A | Fail | 1 | ||||
| 157 | 8/29/2024 9:13 | 54114 | FALSE | 4 | BC213 | Complete | 1 | ||||
| 156 | 8/29/2024 9:13 | 54114 | FALSE | 1 | BC213 | Pass | 1 | ||||
| 155 | 8/29/2024 9:12 | 54167 | FALSE | 1 | CA210 | Pass | 1 | ||||
| 154 | 8/29/2024 9:12 | 54167 | FALSE | 4 | CA210 | Complete | 1 | ||||
| 150 | 8/29/2024 9:04 | 33868 | FALSE | 1 | RW210 | Pass | 1 | ||||
| 149 | 8/29/2024 9:04 | 33868 | FALSE | 4 | RW210 | Complete | 1 | ||||
| 148 | 8/29/2024 9:02 | 10326 | FALSE | 4 | WC006 | Complete | 1 | ||||
| 147 | 8/29/2024 9:00 | 10235 | FALSE | 3 | CA210 | Requested | 1 | Late | Mark it late as the next entry is at 154 which is more than 5 mins | ||
| 146 | 8/29/2024 8:59 | 54114 | FALSE | 3 | BC213 | Requested | 1 | Late | Mark it late as the next entry is at 156 which is more than 5 mins | ||
| 109 | 8/29/2024 7:10 | 34989 | FALSE | 1 | WC100 Side A | Pass | 1 | ||||
| 106 | 8/29/2024 7:09 | 10270 | FALSE | 4 | RW002 | Complete | 1 | ||||
| 105 | 8/29/2024 7:09 | 10270 | FALSE | 3 | RW002 | Requested | 1 | ||||
| 104 | 8/29/2024 7:08 | 34989 | FALSE | 4 | WC100 Side B | Complete | 1 | ||||
| 103 | 8/29/2024 7:08 | 34989 | FALSE | 1 | WC100 Side B | Pass | 1 | ||||
| 102 | 8/29/2024 7:08 | 34989 | FALSE | 3 | WC100 Side B | Requested | 1 | ||||
| 101 | 8/29/2024 7:05 | 10317 | FALSE | 4 | WC011 Side A | Complete | 1 | ||||
| 100 | 8/29/2024 7:05 | 10317 | FALSE | 1 | WC011 Side A | Pass | 1 | ||||
| 99 | 8/29/2024 7:05 | 53914 | FALSE | 4 | PI001 | Complete | 1 | ||||
| 98 | 8/29/2024 7:04 | 10317 | FALSE | 3 | WC011 Side A | Requested | 1 | ||||
| 78 | 8/29/2024 0:59 | 53828 | FALSE | 3 | FT005 | Requested | 3 | Late | Mark it late as the next entry is at 85 which is more than 5 mins | ||
| 66 | 8/28/2024 15:18 | 54245 | FALSE | 4 | PI002 | Complete | 2 | ||||
| 65 | 8/28/2024 15:13 | 54365 | FALSE | 3 | PI002 | Requested | 2 | Delete | Mark it delete since we have 66 even though its different users, could have been supervisor card | ||
| 64 | 8/28/2024 15:10 | 54098 | FALSE | 4 | FT006 | Complete | 2 | ||||
| 63 | 8/28/2024 15:10 | 54098 | FALSE | 1 | FT006 | Pass | 2 | ||||
| 62 | 8/28/2024 15:10 | 54098 | FALSE | 3 | FT006 | Requested | 2 | ||||
| 60 | 8/28/2024 15:09 | 53670 | FALSE | 4 | WC004 Side B | Complete | 2 | ||||
| 61 | 8/28/2024 15:09 | 53955 | FALSE | 4 | WC011 Side A | Complete | 2 | ||||
| 59 | 8/28/2024 15:09 | 53955 | FALSE | 1 | WC011 Side A | Pass | 2 | ||||
| 58 | 8/28/2024 15:08 | 53670 | FALSE | 1 | WC004 Side A | Pass | 2 | ||||
| 57 | 8/28/2024 15:08 | 53955 | FALSE | 3 | WC011 Side A | Requested | 2 | Delete | Mark it delete since we have 59 | ||
| 56 | 8/28/2024 15:07 | 54171 | FALSE | 1 | WC008 Side A | Pass | 2 | ||||
| 55 | 8/28/2024 15:07 | 54171 | FALSE | 4 | WC008 Side A | Complete | 2 | ||||
| 54 | 8/28/2024 15:07 | 53955 | FALSE | 4 | WC011 Side B | Complete | 2 | ||||
| 53 | 8/28/2024 15:07 | 53955 | FALSE | 1 | WC011 Side B | Pass | 2 | ||||
| 52 | 8/28/2024 15:06 | 54171 | FALSE | 3 | WC008 Side A | Requested | 2 | Delete | Mark it delete since we have 55 | ||
| 51 | 8/28/2024 15:06 | 53670 | FALSE | 4 | WC004 Side B | Complete | 2 | ||||
| 50 | 8/28/2024 15:06 | 54171 | FALSE | 4 | WC008 Side B | Complete | 2 | ||||
| 49 | 8/28/2024 15:06 | 54171 | FALSE | 1 | WC008 Side B | Pass | 2 | ||||
| 48 | 8/28/2024 15:05 | 53955 | FALSE | 3 | WC011 Side B | Requested | 2 | Delete | Mark it delete since we have 53 | ||
| 47 | 8/28/2024 15:05 | 54370 | FALSE | 4 | WC100 Side A | Complete | 2 | ||||
| 46 | 8/28/2024 15:05 | 54370 | FALSE | 1 | WC100 Side A | Pass | 2 | ||||
| 45 | 8/28/2024 15:05 | 54370 | FALSE | 3 | WC100 Side A | Requested | 2 | Delete | Mark it delete since we have 46 | ||
| 44 | 8/28/2024 15:05 | 53670 | FALSE | 1 | WC004 Side B | Pass | 2 | ||||
| 43 | 8/28/2024 15:05 | 53712 | FALSE | 1 | FT004 | Pass | 2 | ||||
| 42 | 8/28/2024 15:05 | 53712 | FALSE | 4 | FT004 | Complete | 2 | ||||
| 41 | 8/28/2024 15:04 | 19722 | FALSE | 4 | WC001 | Complete | 2 | ||||
| 40 | 8/28/2024 15:04 | 53712 | FALSE | 3 | FT004 | Requested | 2 | Delete | Mark it delete since we have 42 | ||
| 39 | 8/28/2024 15:04 | 54370 | FALSE | 4 | WC100 Side B | Complete | 2 | ||||
| 38 | 8/28/2024 15:04 | 54370 | FALSE | 1 | WC100 Side B | Pass | 2 | ||||
| 37 | 8/28/2024 15:04 | 53988 | FALSE | 1 | FT005 | Pass | 2 | ||||
| 36 | 8/28/2024 15:04 | 53988 | FALSE | 4 | FT005 | Complete | 2 | ||||
| 35 | 8/28/2024 15:04 | 54171 | FALSE | 3 | WC008 Side B | Requested | 2 | Late | Mark it late since we do not have subsequent entry within 5 mins | ||
| 34 | 8/28/2024 15:03 | 53988 | FALSE | 3 | FT005 | Requested | 2 | Late | Mark it late since we do not have subsequent entry within 5 mins | ||
| 33 | 8/28/2024 15:03 | 54370 | FALSE | 3 | WC100 Side B | Requested | 2 | Late | Mark it late since we do not have subsequent entry within 5 mins | ||
| 32 | 8/28/2024 15:02 | 19722 | FALSE | 3 | WC001 | Requested | 2 | Late | Mark it late since we do not have subsequent entry within 5 mins |