Problems with metric last 12 months previous year.

[Anonymous]

Hi,

I have a question to see if there is any way to answer, I have a metric that shows the last 12 months of the selected month, for example, if I select March 2022 it shows the last 12 months that contain values since that date.

The metric is as follows:

% Test = 
VAR LastSelectedDate =
    MAX ( DimTiempo[Date] )
VAR StartDate =
    EDATE ( LastSelectedDate, -13 )
RETURN
    CALCULATE (
        [% Test 1],
        FILTER (
            ALL ( DimTiempo ),
            DimTiempo[Date] >= StartDate
                && DimTiempo[Date] <= LastSelectedDate
        )
    )

This metric works well, now what I need is the same metric but to show the previous year, the problem is that I need it to show me the values of the previous year but in the same months of the visual:

Basically, I need that in "Visual last 12 month LY measure" the first record of March 2022, it shows me the value that corresponds to the previous year: 3645%, in February 2022 it shows 3608%, etc.
Currently, it shows me blank.

Is there any way to do it?

Thank

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.

Create a measure.

% Test =
VAR StartDate =
    EDATE ( MAX ( DimTiempo[date] ), -12 )
RETURN
    CALCULATE (
        [% Test 1],
        FILTER ( ALL ( DimTiempo ), DimTiempo[Date] = StartDate )
    )

If I have misunderstood your meaning, please provide your desired output with more details and you sample pbix file without privacy information.

Best Regards

Community Support Team _ Polly

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