visual level filter on last 3 completed months

[sreddy47652]

Hi Team, I have an requirement to filter on visual level complete 3 months. I have date column in my report need to filter out only last 3 onths not rolling months. For example we now we are june, i want get filter on last 3 completed months(Mar, April, may) in visual level. How can we do that.

[v-jayw-msft]

Hi @sreddy47652 ,

You could simply use visual level filter:

Best Regards,

Jay

[danextian · Accepted solution]

Hi @sreddy47652 

Try this as a calculated column in your Dates table. Change the table and column names accordingly.

Last 3M =
VAR Start3MonthsAgo =
    EOMONTH ( TODAY (), -4 ) + 1
VAR EndofLastMonth =
    EOMONTH ( TODAY (), -1 )
RETURN
    Dates[Date] >= Start3MonthsAgo
        && Dates[Date] <= EndofLastMonth

.This will return True for those dates within the range. False for otherwise.