Measure for LY that ignores select filter

[Anonymous]

Hi.

I am trying to calculate a measure for a matrix, showing total LY figures. I have 2 slicers, Month & Year. If I select f.ex. 2024 and month May, I would like the new measure to show full 2023 and not only YTD May 2023.

I have tried with ALLEXCEPT, but with no luck....

Current measure: LY Full year = CALCULATE(-SUM('Finance Transactions_V'[Amount]), SAMEPERIODLASTYEAR(Date_V[Date]),ALLEXCEPT(Date_V, Date_V[Year Number]))

Thanks a lot in advance.

[_AAndrade · Accepted solution]

Hi,

Please try this:

VAR Year = MAX(Date_V[Year Number])

RETURN

CALCULATE(
    "Your Sum Measure",
    REMOVEFILTERS(Date_V),
    DATESBETWEEN(Date_V[Date],DATE(Year -1,1,1),DATE(Year -1,12,31))
)

[Anonymous]

It works perfectly! Thanks a lot.

[danextian]

Hi @Anonymous ,

Do you intend to show the value for each past x months as well and not just the correct selected month? You will need a disconnected dates/calendar table for that as using the one related to your fact table will just show what is selected. Please see attached sample pbix.

[Anonymous]

Thanks a lot for your reply. I would like a matrix visual as below, where the right column is full last year in spite of filters. I already have a date table, but this is connected...