Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Select a Maximum Value in a column for current month

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

Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , Seem fine. try like 

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