Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
40 |