DIRECT QUERY equivalent to SAMEPERIODLASTYEAR

Hi everyone,

I'm using a SQL DB (DirectQuery  mode) as a datasource for my report.

I have a DateTable and SalesTable.

My goal is to have a report with:

- 2 slicers: 1 for years; 1 for months

- 1 List visual with 3 columns: YearMonth, Sales Amt, SalesAmt Previous Year

I tried the following, according to some examples I found online:

Total SalesAmt PY  =
    CALCULATE(
        [Total SalesAmt],
        FILTER(
            ALL(DateTable[Date Value]),
            AND(
                DateTable[Date Value]>=EDATE(MIN(DateTable[Date Value]),-12),
                DateTable[Date Value]<=EDATE(MAX(DateTable[Date Value]),-12)
            )
        )
    )

The problem is that, if I select more than one non-consecutive month (let's say, Feb and May), since the formula uses MIN and MAX, the result of this formula will include Feb, Mar, Apr and May.

Could someone please let me know how to achieve this?

Thanks!