Forum Discussion
ajitsahoo8338
Helper III
Helper IIII need some with one logic
Hello Everyone I need help with one logic. My Data looks like this. Employee Name Date Work Hours David 11/18/2024 8 David 11/19/2024 8 David 11/20/2024 8 ...
ajitsahoo8338Helper III
Helper IIIHello Suresh604
Thank you for your response. This is not working when the date filter is applied. Please check below.
ajitsahoo8338Helper III
Helper IIIHello Suresh604 This works but If add a date slicer then it is not working. Can you please try this below using a date slicer
| Employee | Date | Work Hours |
| Amy | 3/11/2024 0:00 | 8 |
| Amy | 3/12/2024 0:00 | 8 |
| Amy | 3/13/2024 0:00 | 8 |
| Amy | 3/14/2024 0:00 | 8 |
| Amy | 3/15/2024 0:00 | 8 |
| Amy | 3/18/2024 0:00 | 8 |
| Amy | 3/19/2024 0:00 | 8 |
| Amy | 3/20/2024 0:00 | 8 |
| Amy | 3/21/2024 0:00 | 8 |
| Amy | 3/22/2024 0:00 | 8 |
| Amy | 3/25/2024 0:00 | 8 |
| Amy | 3/26/2024 0:00 | 9 |
| Amy | 3/27/2024 0:00 | 8 |
| Amy | 3/28/2024 0:00 | 8 |
| Amy | 3/29/2024 0:00 | 8.5 |
| Amy | 4/1/2024 0:00 | 8.5 |
| Amy | 4/2/2024 0:00 | 8 |
| Amy | 4/3/2024 0:00 | 10.5 |
| Amy | 4/4/2024 0:00 | 8.5 |
| Amy | 4/5/2024 0:00 | 8.5 |
| Amy | 4/8/2024 0:00 | 6.5 |
| Amy | 4/9/2024 0:00 | 8.5 |
| Amy | 4/10/2024 0:00 | 9 |
| Amy | 4/11/2024 0:00 | 10 |
| Amy | 4/12/2024 0:00 | 8 |
| Amy | 4/15/2024 0:00 | 9 |
| Amy | 4/16/2024 0:00 | 9 |
| Amy | 4/17/2024 0:00 | 9 |
| Amy | 4/18/2024 0:00 | 7 |
| Amy | 4/19/2024 0:00 | 7.5 |
| Amy | 4/22/2024 0:00 | 9.5 |
| Amy | 4/23/2024 0:00 | 9 |
| Amy | 4/24/2024 0:00 | 8 |
| Amy | 4/25/2024 0:00 | 7 |
| Amy | 4/26/2024 0:00 | 8 |
| Amy | 4/29/2024 0:00 | 9 |
| Amy | 4/30/2024 0:00 | 7.5 |
| Amy | 5/1/2024 0:00 | 8 |
| Amy | 5/2/2024 0:00 | 8 |
| Amy | 5/3/2024 0:00 | 8 |
| Amy | 5/6/2024 0:00 | 8 |
| Amy | 5/7/2024 0:00 | 7 |
| Amy | 5/8/2024 0:00 | 8.5 |
| Amy | 5/9/2024 0:00 | 8.5 |
| Amy | 5/10/2024 0:00 | 8 |
| Amy | 5/13/2024 0:00 | 8 |
| Amy | 5/14/2024 0:00 | 9 |
| Amy | 5/15/2024 0:00 | 8.5 |
| Amy | 5/16/2024 0:00 | 8.5 |
| Amy | 5/17/2024 0:00 | 8 |
| Amy | 5/20/2024 0:00 | 9 |
| Amy | 5/21/2024 0:00 | 8 |
| Amy | 5/22/2024 0:00 | 8 |
| Amy | 5/23/2024 0:00 | 8 |
| Amy | 5/24/2024 0:00 | 8 |
| Amy | 5/27/2024 0:00 | 8 |
| Amy | 5/28/2024 0:00 | 8 |
| Amy | 5/29/2024 0:00 | 8 |
| Amy | 5/30/2024 0:00 | 9 |
| Amy | 5/31/2024 0:00 | 8 |
| Amy | 6/3/2024 0:00 | 8.5 |
| Amy | 6/4/2024 0:00 | 8 |
| Amy | 6/5/2024 0:00 | 12.5 |
| Amy | 6/6/2024 0:00 | 6 |
| Amy | 6/7/2024 0:00 | 8 |
| Amy | 6/10/2024 0:00 | 8 |
| Amy | 6/11/2024 0:00 | 8.5 |
| Amy | 6/12/2024 0:00 | 8 |
| Amy | 6/13/2024 0:00 | 8 |
| Amy | 6/14/2024 0:00 | 8 |
| Amy | 6/17/2024 0:00 | 8 |
| Amy | 6/18/2024 0:00 | 7.5 |
| Amy | 6/19/2024 0:00 | 7.5 |
| Amy | 6/20/2024 0:00 | 8 |
| Amy | 6/21/2024 0:00 | 8.5 |
| Amy | 6/24/2024 0:00 | 8 |
| Amy | 6/25/2024 0:00 | 8 |
| Amy | 6/26/2024 0:00 | 8.5 |
| Amy | 6/27/2024 0:00 | 8 |
| Amy | 6/28/2024 0:00 | 8.5 |
| Amy | 7/1/2024 0:00 | 8 |
| Amy | 7/2/2024 0:00 | 8 |
| Amy | 7/3/2024 0:00 | 8 |
| Amy | 7/4/2024 0:00 | 8 |
| Amy | 7/5/2024 0:00 | 8 |
| Amy | 7/8/2024 0:00 | 8 |
| Amy | 7/9/2024 0:00 | 8 |
| Amy | 7/10/2024 0:00 | 8 |
| Amy | 7/11/2024 0:00 | 8 |
| Amy | 7/12/2024 0:00 | 8 |
| Amy | 7/15/2024 0:00 | 8.5 |
| Amy | 7/16/2024 0:00 | 8.5 |
| Amy | 7/17/2024 0:00 | 8 |
| Amy | 7/18/2024 0:00 | 7.5 |
| Amy | 7/19/2024 0:00 | 7.5 |
| Amy | 7/22/2024 0:00 | 8.8 |
| Amy | 7/23/2024 0:00 | 8 |
| Amy | 7/24/2024 0:00 | 8 |
| Amy | 7/25/2024 0:00 | 6.2 |
| Amy | 7/26/2024 0:00 | 8 |
| Amy | 7/29/2024 0:00 | 8 |
| Amy | 7/30/2024 0:00 | 8 |
| Amy | 7/31/2024 0:00 | 8 |
| Amy | 8/1/2024 0:00 | 8 |
| Amy | 8/2/2024 0:00 | 8 |
| Amy | 8/5/2024 0:00 | 8 |
| Amy | 8/6/2024 0:00 | 8 |
| Amy | 8/7/2024 0:00 | 8 |
| Amy | 8/8/2024 0:00 | 8 |
| Amy | 8/9/2024 0:00 | 8 |
| Amy | 8/12/2024 0:00 | 8 |
| Amy | 8/13/2024 0:00 | 9 |
| Amy | 8/14/2024 0:00 | 9.8 |
| Amy | 8/15/2024 0:00 | 10 |
| Amy | 8/16/2024 0:00 | 8 |
| Amy | 8/19/2024 0:00 | 8 |
| Amy | 8/20/2024 0:00 | 7 |
| Amy | 8/21/2024 0:00 | 9 |
| Amy | 8/22/2024 0:00 | 8 |
| Amy | 8/23/2024 0:00 | 8 |
| Amy | 8/26/2024 0:00 | 8 |
| Amy | 8/27/2024 0:00 | 8 |
| Amy | 8/28/2024 0:00 | 8 |
| Amy | 8/29/2024 0:00 | 8 |
| Amy | 8/30/2024 0:00 | 8 |
| Amy | 9/2/2024 0:00 | 8 |
| Amy | 9/3/2024 0:00 | 8 |
| Amy | 9/4/2024 0:00 | 8 |
| Amy | 9/5/2024 0:00 | 8 |
| Amy | 9/6/2024 0:00 | 9 |
| Amy | 9/9/2024 0:00 | 7 |
| Amy | 9/10/2024 0:00 | 8.5 |
| Amy | 9/11/2024 0:00 | 8 |
| Amy | 9/12/2024 0:00 | 7 |
| Amy | 9/13/2024 0:00 | 9 |
| Amy | 9/16/2024 0:00 | 8 |
| Amy | 9/17/2024 0:00 | 8.5 |
| Amy | 9/18/2024 0:00 | 8 |
| Amy | 9/19/2024 0:00 | 7.5 |
| Amy | 9/20/2024 0:00 | 8 |
| Amy | 9/23/2024 0:00 | 7.5 |
| Amy | 9/24/2024 0:00 | 8.5 |
| Amy | 9/25/2024 0:00 | 8 |
| Amy | 9/26/2024 0:00 | 8 |
| Amy | 9/27/2024 0:00 | 8 |
| Amy | 9/30/2024 0:00 | 8 |
| Amy | 10/1/2024 0:00 | 8 |
| Amy | 10/2/2024 0:00 | 8 |
| Amy | 10/3/2024 0:00 | 8 |
| Amy | 10/4/2024 0:00 | 8 |
| Amy | 10/7/2024 0:00 | 9.5 |
| Amy | 10/8/2024 0:00 | 7.5 |
| Amy | 10/9/2024 0:00 | 8.5 |
| Amy | 10/10/2024 0:00 | 8 |
| Amy | 10/11/2024 0:00 | 7 |
| Amy | 10/14/2024 0:00 | 7.5 |
| Amy | 10/15/2024 0:00 | 8 |
| Amy | 10/16/2024 0:00 | 8.5 |
| Amy | 10/17/2024 0:00 | 8 |
| Amy | 10/18/2024 0:00 | 8 |
| Amy | 10/21/2024 0:00 | 8 |
| Amy | 10/22/2024 0:00 | 8 |
| Amy | 10/23/2024 0:00 | 8 |
| Amy | 10/24/2024 0:00 | 8 |
| Amy | 10/25/2024 0:00 | 8 |
| Amy | 10/28/2024 0:00 | 7.5 |
| Amy | 10/29/2024 0:00 | 8 |
| Amy | 10/30/2024 0:00 | 8.5 |
| Amy | 10/31/2024 0:00 | 8 |
| Amy | 11/1/2024 0:00 | 8 |
| Amy | 11/4/2024 0:00 | 8 |
| Amy | 11/5/2024 0:00 | 8 |
| Amy | 11/6/2024 0:00 | 8 |
| Amy | 11/7/2024 0:00 | 8.5 |
| Amy | 11/8/2024 0:00 | 8 |
| Amy | 11/11/2024 0:00 | 8.2 |
| Amy | 11/12/2024 0:00 | 8 |
| Amy | 11/13/2024 0:00 | 8 |
| Amy | 11/14/2024 0:00 | 8 |
| Amy | 11/15/2024 0:00 | 8 |
| Amy | 11/18/2024 0:00 | 7 |
| Amy | 11/19/2024 0:00 | 10 |
| Amy | 11/20/2024 0:00 | 8.5 |
| Amy | 11/21/2024 0:00 | 8 |
| Amy | 11/22/2024 0:00 | 8 |
| Amy | 11/25/2024 0:00 | 8 |
| Amy | 11/26/2024 0:00 | 8 |
| Amy | 11/27/2024 0:00 | 8 |
| Amy | 11/28/2024 0:00 | 8 |
| Amy | 11/29/2024 0:00 | 8 |