Forum Discussion

ajitsahoo8338's avatar
ajitsahoo8338
Icon for Helper III rankHelper III
1 year ago

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 ...
Need Help
Tips and Tricks
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

Hi ajitsahoo8338 

You can use measure like :

Fixed_ = SUMX('Table', IF('Table'[Work Hours]<=8,'Table'[Work Hours],8))

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.

 
ajitsahoo8338's avatar
ajitsahoo8338
Icon for Helper III rankHelper III
1 year ago

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

EmployeeDateWork Hours
Amy3/11/2024 0:008
Amy3/12/2024 0:008
Amy3/13/2024 0:008
Amy3/14/2024 0:008
Amy3/15/2024 0:008
Amy3/18/2024 0:008
Amy3/19/2024 0:008
Amy3/20/2024 0:008
Amy3/21/2024 0:008
Amy3/22/2024 0:008
Amy3/25/2024 0:008
Amy3/26/2024 0:009
Amy3/27/2024 0:008
Amy3/28/2024 0:008
Amy3/29/2024 0:008.5
Amy4/1/2024 0:008.5
Amy4/2/2024 0:008
Amy4/3/2024 0:0010.5
Amy4/4/2024 0:008.5
Amy4/5/2024 0:008.5
Amy4/8/2024 0:006.5
Amy4/9/2024 0:008.5
Amy4/10/2024 0:009
Amy4/11/2024 0:0010
Amy4/12/2024 0:008
Amy4/15/2024 0:009
Amy4/16/2024 0:009
Amy4/17/2024 0:009
Amy4/18/2024 0:007
Amy4/19/2024 0:007.5
Amy4/22/2024 0:009.5
Amy4/23/2024 0:009
Amy4/24/2024 0:008
Amy4/25/2024 0:007
Amy4/26/2024 0:008
Amy4/29/2024 0:009
Amy4/30/2024 0:007.5
Amy5/1/2024 0:008
Amy5/2/2024 0:008
Amy5/3/2024 0:008
Amy5/6/2024 0:008
Amy5/7/2024 0:007
Amy5/8/2024 0:008.5
Amy5/9/2024 0:008.5
Amy5/10/2024 0:008
Amy5/13/2024 0:008
Amy5/14/2024 0:009
Amy5/15/2024 0:008.5
Amy5/16/2024 0:008.5
Amy5/17/2024 0:008
Amy5/20/2024 0:009
Amy5/21/2024 0:008
Amy5/22/2024 0:008
Amy5/23/2024 0:008
Amy5/24/2024 0:008
Amy5/27/2024 0:008
Amy5/28/2024 0:008
Amy5/29/2024 0:008
Amy5/30/2024 0:009
Amy5/31/2024 0:008
Amy6/3/2024 0:008.5
Amy6/4/2024 0:008
Amy6/5/2024 0:0012.5
Amy6/6/2024 0:006
Amy6/7/2024 0:008
Amy6/10/2024 0:008
Amy6/11/2024 0:008.5
Amy6/12/2024 0:008
Amy6/13/2024 0:008
Amy6/14/2024 0:008
Amy6/17/2024 0:008
Amy6/18/2024 0:007.5
Amy6/19/2024 0:007.5
Amy6/20/2024 0:008
Amy6/21/2024 0:008.5
Amy6/24/2024 0:008
Amy6/25/2024 0:008
Amy6/26/2024 0:008.5
Amy6/27/2024 0:008
Amy6/28/2024 0:008.5
Amy7/1/2024 0:008
Amy7/2/2024 0:008
Amy7/3/2024 0:008
Amy7/4/2024 0:008
Amy7/5/2024 0:008
Amy7/8/2024 0:008
Amy7/9/2024 0:008
Amy7/10/2024 0:008
Amy7/11/2024 0:008
Amy7/12/2024 0:008
Amy7/15/2024 0:008.5
Amy7/16/2024 0:008.5
Amy7/17/2024 0:008
Amy7/18/2024 0:007.5
Amy7/19/2024 0:007.5
Amy7/22/2024 0:008.8
Amy7/23/2024 0:008
Amy7/24/2024 0:008
Amy7/25/2024 0:006.2
Amy7/26/2024 0:008
Amy7/29/2024 0:008
Amy7/30/2024 0:008
Amy7/31/2024 0:008
Amy8/1/2024 0:008
Amy8/2/2024 0:008
Amy8/5/2024 0:008
Amy8/6/2024 0:008
Amy8/7/2024 0:008
Amy8/8/2024 0:008
Amy8/9/2024 0:008
Amy8/12/2024 0:008
Amy8/13/2024 0:009
Amy8/14/2024 0:009.8
Amy8/15/2024 0:0010
Amy8/16/2024 0:008
Amy8/19/2024 0:008
Amy8/20/2024 0:007
Amy8/21/2024 0:009
Amy8/22/2024 0:008
Amy8/23/2024 0:008
Amy8/26/2024 0:008
Amy8/27/2024 0:008
Amy8/28/2024 0:008
Amy8/29/2024 0:008
Amy8/30/2024 0:008
Amy9/2/2024 0:008
Amy9/3/2024 0:008
Amy9/4/2024 0:008
Amy9/5/2024 0:008
Amy9/6/2024 0:009
Amy9/9/2024 0:007
Amy9/10/2024 0:008.5
Amy9/11/2024 0:008
Amy9/12/2024 0:007
Amy9/13/2024 0:009
Amy9/16/2024 0:008
Amy9/17/2024 0:008.5
Amy9/18/2024 0:008
Amy9/19/2024 0:007.5
Amy9/20/2024 0:008
Amy9/23/2024 0:007.5
Amy9/24/2024 0:008.5
Amy9/25/2024 0:008
Amy9/26/2024 0:008
Amy9/27/2024 0:008
Amy9/30/2024 0:008
Amy10/1/2024 0:008
Amy10/2/2024 0:008
Amy10/3/2024 0:008
Amy10/4/2024 0:008
Amy10/7/2024 0:009.5
Amy10/8/2024 0:007.5
Amy10/9/2024 0:008.5
Amy10/10/2024 0:008
Amy10/11/2024 0:007
Amy10/14/2024 0:007.5
Amy10/15/2024 0:008
Amy10/16/2024 0:008.5
Amy10/17/2024 0:008
Amy10/18/2024 0:008
Amy10/21/2024 0:008
Amy10/22/2024 0:008
Amy10/23/2024 0:008
Amy10/24/2024 0:008
Amy10/25/2024 0:008
Amy10/28/2024 0:007.5
Amy10/29/2024 0:008
Amy10/30/2024 0:008.5
Amy10/31/2024 0:008
Amy11/1/2024 0:008
Amy11/4/2024 0:008
Amy11/5/2024 0:008
Amy11/6/2024 0:008
Amy11/7/2024 0:008.5
Amy11/8/2024 0:008
Amy11/11/2024 0:008.2
Amy11/12/2024 0:008
Amy11/13/2024 0:008
Amy11/14/2024 0:008
Amy11/15/2024 0:008
Amy11/18/2024 0:007
Amy11/19/2024 0:0010
Amy11/20/2024 0:008.5
Amy11/21/2024 0:008
Amy11/22/2024 0:008
Amy11/25/2024 0:008
Amy11/26/2024 0:008
Amy11/27/2024 0:008
Amy11/28/2024 0:008
Amy11/29/2024 0:008
  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    1 year ago

    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.

    • ajitsahoo8338's avatar
      ajitsahoo8338
      Icon for Helper III rankHelper III
      1 year ago

      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