Maximum working day per month

[Joshua_]

Hello Team,

I am working with my calendar table and I need to enter the maximum day worked per month. I integrated a holiday data table in my data model and with that I get the Wordays column this month, but I am having a problem adding a column with the maximum day per month.

thank a lot!

[daxer-almighty]

[Monthly Max Business Day] = // calculated column
var CurrentMonth = T[Month]
var CurrentYear = T[Year]
var MonthlyMaxBusinessDay = 
    MAXX(
        filter(
            T,
            T[Month] = CurrentMonth
            && T[Year] = CurrentYear
            && T[Business Day] = 1
        ),
        T[Date]
    )
return
    MonthlyMaxBusinessDay