Forum Discussion
I 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 ...
Hello Ritaf1983 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 |
Ritaf1983
Super User
Super UserHו Anonymous
Tried with the slicer and worked perfectly too
you can download the updated pbix and follow ...
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hello Ritaf1983 It is working for this dataset. but in my original dataset, I don't know why it is not working. I have 100 employees