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 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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!