Select a Maximum Value in a column for current month

[Anonymous]

Working Days by Month   The Table i'm using for calculating a measure

I'm using the measure:
Calculate (max('table2'Totalworkdays), filter(Table2, format('table2'[Date], "mmmm yyyy") = format(today(), "mmmm yyyy")
i'm getting 23 instead of 22, does anyone knows wh
y,  please help

[v-chuncz-msft]

@Anonymous 

You may try using DATEDIFF instead of FORMAT.

[amitchandak]

@Anonymous , Seem fine. try like

Calculate (max('table2'Totalworkdays), filter(all(Table2), format('table2'[Date], "yyyymm") = format(today(), "yyyymm")))