Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts, in need of assistance on how to create a DAX formular to reduce the number of work days & hours, based on an average of leave per mth/ yr over actual......
My scenario is I have multiple employees (1500) working across multiple projects (6000+ pa) nationally (different public holiday dates) and various types of leave, e.g. 4wks annual, careers leave, volunteer leave, sick leave, etc etc.....Ans of course none of my data sources actually align or provide me with the necessary data.
So, to keep things simple, I am looking for your expert advice on a DAX solution/ formular to average out all potential leave = 42 days per calendar year @ 3.5 days per month as non work days
I have a 'Date Table' that has a measure based on work days Being based on Mon to Fri & another Colin calculating work days * 7.35 (hrs worked per day)
What I now need to include is leave work days, e.g. 23days = 19.5days & hours are 169 to 144
Any and all advice greatly appreciated
Hi @robhel,
From your description, I could not understand what result you want to show? Could you please post me your data stucture and your desired result?
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |