Insert Column for Max Working Days in a Month

[StuM]

Hi

I'm trying to insert a new column to show the number of working days in a month to be used for budget calculations as I need to align monthly budgets with daily sales.  I've created a YearMonth column to give me a unique identifier for each month and want to find the maximum value of WorkingDaysMTD for each month and want to insert this as a new column. 

TIA

[StuM · Accepted solution]

Found the answer by modifying @Fowmy s solution here

I'm sure there may be a better or more elegant way to do this but I'm new to PBI so have to go with what works to start with

MaxWDinMonth =

VAR __YEAR = 'Calendar'[Year]

VAR __MONTH = 'Calendar'[Month]

RETURN

MAXX(

FILTER(

'Calendar',

'Calendar'[Year] = __YEAR && 'Calendar'[Month] = __MONTH && 'Calendar'[WorkingDaysMTD] > 0

),

'Calendar'[WorkingDaysMTD]

)