HI @Iwona
The simplest way to do this is to have a column in the date table marking dates prior to current period.
Assuming your data is real time ish then we can work with today and add the following column to the Calendar
IsBeforeCurrentPeriod =
Var BeginningOfPeriod = Date(Year(today()),Month(today()),1)
Return
IF('Calendar'[Date]<BeginningOfPeriod,1,0)
Then bring this column into the visual filter and filter for 1.
An alternative solution which will offer date flexibility across the whole solution and make time intelligence easier is to have a period offset column reading 0 for current month, -1 for last month, -2 for 2 months ago, 1 for next month etc.
@Melissa 's date table in power query offers this but I’m not sure whether it works the year offset through for non-calendar year.
Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum
Cheers
Pete