How to show last 2 years data using measure?

[Happy2023_05]

Hi All,

I have date table with 3 yrs of data.When I want to bring the date to slicer I should see only 2 yrs of data. For eg slicer should show 2022 and 2021. Next year it should be 2023 and 2022. It should not be hard-coded in filters.

Automatically only 2 yrs value should be shown in slicer

Can we bring this in measure?

Any help is much appreciated

[Jihwan_Kim]

Hi,

one of ways to achieve this is to create a measure something like below, and put it into Visual Filter pane and set it up like below.

Please also check the attached pbix file.

Last two years measure: = 
VAR _currentyear =
    YEAR ( TODAY () )
VAR _previousyear = _currentyear - 1
RETURN
    IF (
        SELECTEDVALUE ( 'Year'[Year] ) = _currentyear
            || SELECTEDVALUE ( 'Year'[Year] ) = _previousyear,
        1,
        0
    )

[Happy2023_05]

Thank you so much.But when I try to apply this measure for all pages I could not bring the measure to filter on all pages. Is there any other way to do it?

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your feedback.

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

One of ways is to apply calculated column to report level filter pane.