Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have broken out my estimated Man Weeks per month for a workforce planning chart. But I need to divide this by the total number of weeks in a month to give me my estimated man power needs as an average for the month.
I tried using the below formula in an added column in my Date Table but it was coming back with some as saying 6 weeks in a certain month. For my purposes I'm using if it is a Saturday as my weekly cut off. So for example the lsat day of February 2017 would be on the 25th and the month would only contain 4 weeks.
Solved! Go to Solution.
You could add a column to your date table called
Is saturday = if (weekday ([date],1) =7,1,0)
Then sum that for each month
You could add a column to your date table called
Is saturday = if (weekday ([date],1) =7,1,0)
Then sum that for each month
Thats alright @dkay84_PowerBI based on how my company calculates our month ends this solution will work.
You will need to create a calendar table that calculates and flags the last day of each month based on your logic. Then you can create a formula that will calculate the date difference between the last day of month (actual) and the flagged last date of month (your logic). Subtract that difference from the total days in the month and divide by 4 (and sounds like round up will be needed to).
I will get back to you with an exact solution but try thinking about what I recommend and see if you can come up with something.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
116 | |
82 | |
47 | |
42 | |
29 |
User | Count |
---|---|
186 | |
80 | |
72 | |
48 | |
45 |