Filter to latest 12 calendar months, excluding latest 2 months

[niko18033]

I'm trying to filter to the last 12 full months of data, excluding the last 2. While the default relative date last 12 calendar months does limit to the last complete calendar month, I'd like to exclude that month as well. Current Output is able to do Jun 2020 - Jul 2021 (relative date filter: latest 13 calendar months)

Assuming the date is Aug 26, 2021 (or any date in Aug): this should be the desired output for the column: Jul 2020 - Jun 2021

Jul 2020

Aug 2020

Sep 2020

Oct 2020

Nov 2020

Dec 2020

Jan 2021

Feb 2021

Mar 2021

Apr 2021

May 2021

June 2021

Here's the column I have so far, but it's not working:

Calendar exc Latest 2 Months =

DATESBETWEEN(Table[Month Field],

DATEADD(LASTDATE(Table[Month Field]), -13, MONTH),

DATEADD(LASTDATE(Table[Month Field]), -2, MONTH))

Here's the error message I receive: A table of multiple values was supplied where a single value was expected.

Month Field is an aggregation of my date field (new group, bin size = 1 month).

Any assistance would be much appreciated!

[V-pazhen-msft · Accepted solution]

@niko18033 

Here are the steps you can follow：

1. Create calculated table.

Calendar =
CALENDAR(DATE(2020,1,1),DATE(2021,12,30))

2. Create measure.

Measure =
IF(
    MAX('Calendar'[Date])>=DATE(YEAR(TODAY())-1,MONTH(TODAY())-1,1)&&MAX('Calendar'[Date])<=EOMONTH(TODAY(),-2),1,0)

3. Place the measure in Filters, set is =1, apply.

4. Result:

Shown is July 2020-June 2021

Best Regards,

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

[PaulDBrown]

this thread might help:

https://community.powerbi.com/t5/Desktop/Last-12-Months-of-Running-Total-Measure/m-p/2040639#M764481 

or this alternative method (though the explanation is in Spanish 

https://community.powerbi.com/t5/Desktop/MOSTRAR-valores-HASTA-EL-MES-FILTRADO-Mostrar-SUMA-de-venta... 

or if those aren't helpful, please post sample data or a sample PBIX file