Forum Discussion

chris_rowley's avatar
chris_rowley
Frequent Visitor
5 years ago
Solved

SumIF less than a specified number

Hi all   I have a table that contains data pulled from our time recording system. After some manipulation I have these fields: Total_Hours_Per_week Hourly_Rate Max_hours_Per_Month Each staff ...
Need Help
  • P_D_G's avatar
    P_D_G
    5 years ago

    Thanks for the expmalation. This part is clear. I'm not sure why the solution we provided is not working, which part is expected to work differnetly.

     

    Please have a look at this PBIX file and point me in the right direction. This is what I have:

     

     

     

    Thanks

P_D_G's avatar
P_D_G
Icon for Resolver III rankResolver III
5 years ago

Thanks for the expmalation. This part is clear. I'm not sure why the solution we provided is not working, which part is expected to work differnetly.

 

Please have a look at this PBIX file and point me in the right direction. This is what I have:

 

 

 

Thanks

chris_rowley's avatar
chris_rowley
Frequent Visitor
5 years ago

thank you to P_D_G

 

after creating some new visuals and a couple of tweaks with filters the formula now works correctly. my final figures are still slightly out but i fear there maybe something in my underlying data that could be at fault.

 

thank you for your assistance it has been much appreciated.