Power Bi help

Anonymous · ‎03-13-2023

Hi,

I'm trying to do a formula where if the weekly hours are compared to the standard contract hours.

The formula isnt working for the sum of hours. If it is 37.5 or less than 40 it says hours sufficient however it isn't working.

How do I do a weekly count as the sum isnt working.

KNP · ‎03-13-2023

Hi @Anonymous,

You've posted in the Power Query forum, do you want/need this to be a Power Query solution or would DAX be ok?

Please paste data, not just a screen shot. You'll get an answer much faster with usable data posted.

Thanks

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.