Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
David | 11/21/2024 | 8 |
David | 11/22/2024 | 0 |
My requirement is to create a measure or calculated column. The logic would be: If Work Hours = 8, then Work Hours; if Work Hours>8, then 8.
I tried this below DAX.
IF(SUM(Employee_Hrs[Work Hours])<=8,SUM(Employee_Hrs[Work Hours]),8).
The logic is working correctly but the total is not.
Employee Name | Date | Work Hours | New Measure |
David | 11/18/2024 | 8 | 8 |
David | 11/19/2024 | 8 | 8 |
David | 11/20/2024 | 8 | 8 |
David | 11/21/2024 | 8 | 8 |
David | 11/22/2024 | 0 | 0 |
Total | 32 | 8 |
Hi @ajitsahoo8338 ,
Why don't we create a calculated column for the logic that you need, then aggregate them using a measure?
Would that work for you?
Correct Measure
New Measure =
SUMX(
Employee_Hrs,
IF(Employee_Hrs[Work Hours] <= 8, Employee_Hrs[Work Hours], 😎
)
This approach ensures that the total reflects the sum of the individual row calculations.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Hello @Kedar_Pande 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 |
Hi @ajitsahoo8338 ,
You can follow the below step:
Create a Measure in Power BI:
Write the Correct DAX Formula:
This measure will ensure that each row is calculated correctly and that the total reflects the sum of these calculations. Your data and results should now look like this:
Employee Name Date Work Hours New Measure
David | 11/18/2024 | 8 | 8 |
David | 11/19/2024 | 8 | 8 |
David | 11/20/2024 | 8 | 8 |
David | 11/21/2024 | 8 | 8 |
David | 11/22/2024 | 0 | 0 |
Total | 32 | 32 |
Now, the total of the "New Measure" column should correctly add up to 32, reflecting the sum of each individual row calculation.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Suresh Patra
https://www.linkedin.com/in/sureshpatra
Hello @Suresh604
Thank you for your response. This is not working when the date filter is applied. Please check below.
Hey @ajitsahoo8338 , Can you please check with your data model or the relationship?
Hello @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 |
You can use measure like :
The total is correct, i added ra ow to show what happened with more than 8 hours
The pbix ix attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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 |
Hו @ajitsahoo8338
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
Hello @Ritaf1983 Thank you for your response. This is not working when the date filter is applied. Please check below.
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |