Choose period in column matrix

[hnoriega]

Hi, I have a matrix with information. I want to show the sales depending on what the user wants (month, trimester or year)

The column of the matrix should change depending on that:

This is what I actually have but it´s not working (I cannot add as a column in the matrix)

ATM =
IF (
ISFILTERED ( Periodo[Valor]) && HASONEVALUE (Periodo[Valor] ),
if(LASTNONBLANK (Periodo[Valor], 0 )="Año",
VALUES(Informe_Cadenas_Final[YearMonth]),
if(LASTNONBLANK (Table1[Valor], 0 )="Trim",
values(Informe_Cadenas_Final[YearMonth])
)
),
VALUES(Informe_Cadenas_Final[Mes])
)

Is there any solution?

Thanks!!

[v-shex-msft]

Hi @hnoriega,

I modified your formula, you can try it if it suitable for your requirement.

ATM =
IF (
    SELECTEDVALUE ( Table1[Valor] ) <> BLANK (),
    LASTNONBLANK(Informe_Cadenas_Final[YearMonth],[YearMonth] ),
    SUM( Informe_Cadenas_Final[Mes] )
)

If above not help, it will be help if you share some sample data for test.

Regards,

Xiaoxin Sheng