Calculating the number of working days between a start and end date but split by month

[Jonnyjanso]

Hey so I have imported data which shows an activity and its start and end date:

I need to see how many working days (Mon to Fri) there are for each month between the start and end dates:

Ideally this would woud also exclude holidays etc. I do have a table (not on PowerBI) that shows each day and if it is a holiday etc so wonder if i could import that and make use of that to help calculate the working days.

My struggle is understanding how / where to get the months seperated out and showing the working days within that specific month. The are various people that work on the different activities who have the same start and end date issue and cost linked to each so to seperate out the days i can then create a visual to show the cost per month for each person or activity.

Hopefully this makes sense. As i know it must be possible just at a dead end researching it atm.

[Anonymous]

Hi,

Have you tried using the (new) formula NETWORKDAYS()?
https://docs.microsoft.com/en-us/dax/networkdays-dax

[Jonnyjanso]

Thanks, No didn't know about that formula, that is useful to find the total days (minus Weekends & Holidays) just need to get that split by months now

[Anonymous]

Could you maybe share some sample data?
In a matrix chart you would have to use months for the column and the created measure for values while keeping the activity on rows.