Remove current month from MTD

Anonymous , Create a column like this and use that as a visual level filter

Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),-1), 1,0
)

 

filter for 1

Hi Anonymous 

You can try my way to build a measure filter as well.

My Sample:

MTD and YearMonth are calculated columns. I build YearMonth column to sort MTD column.

Measure:

MTD Filter =
VAR _YearMonth =
    YEAR ( TODAY () ) * 100
        + MONTH ( TODAY () )
RETURN
    IF ( MAX ( 'Table'[YearMonth] ) < _YearMonth, 1, 0 )

Add this measure into Slicer's visual filter: 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.