Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Number of Weeks in a month

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.

1 ACCEPTED SOLUTION
Microsoft Employee

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

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

5 REPLIES 5
Microsoft Employee

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

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Microsoft Employee
I'm not sure that will work. Take a look at April, which starts on a Saturday. There possibly needs to be more logic involved, but only the original poster will know if this works.
Frequent Visitor

Thats alright @dkay84_PowerBI based on how my company calculates our month ends this solution will work.

Frequent Visitor

That works out perfectly thanks for the help @Phil_Seamark

Microsoft Employee

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.

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors