Hello Power BI gurus,
Looking for help in achieving the following. Thank you akready for the support.
1. I have list of employees who post Hours on daily basis.
2. The maximum total hours per day are based on the day of the week for ex: monday to friday are 8 hr, and sat-sun 0 hr. I am creating a separate mapping table to store this value.
3. I want to compare the actual hours Vs the max hours.
The final DAX measures I am looking for is:
Count of number of days per month per person when Actual Hours > Max Hours
Count of number of days per month per person when Actual Hours < Max Hours
Also, if possible can I do conditional formatting based on these criteria?
Go to Solution.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
View solution in original post
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.