How to filter one data and see two periods on columns?

[Meirieli]

Hello. 

I have two slicers, one with year and other with month (both required).

The idea is: When I select year and month, one colunm return the period selected and other colunm return the values from last december before selected period.

Example:

IF I selected May 2018, columns return May 2018 and December 2017;

If I select April 2016, return April 2016 and December 2015.

The actual values it´s ok.

But, when I select the period, the column Exposition Last December doesn´t work.

Can someone help me?

[MFelix · Accepted solution]

Hi @Meirieli,

I'm assuming you want MTD values:

Use something like this:

Exposition Last December = 
CALCULATE (
    SUM ( Table[Value] );
    FILTER (
        ALL ( Table[Date] );
        MONTH ( Table[Date] ) = 12
            && YEAR ( Table[Date] ) = ( YEAR ( MAX ( Table[Date] ) ) -1)
    )
)

Any questions please tell me

Regards

MFelix

[Meirieli]

@MFelix, it´s just I need! Tks! \o/