Medida con error

[JoséVP]

saludo!!

Esperando que se encuentren bien, tengo un problema con una formula (la función max solo acepta una referencia de columna como argumento).

AAP 2021 Acum = CALCULATE([IAAP],

FILTER(ALLSELECTED('Tabla Calendario 2'[Fecha]),

MONTH('Tabla Calendario 2'[Fecha])<=MAX(MONTH('Tabla Calendario 2'[Fecha])) && YEAR('Tabla Calendario 2'[Fecha])<=MAX(YEAR('Tabla Calendario 2'[Fecha]))))

[v-shex-msft · Accepted solution]

HI @JoséVP,

It seems like you want a yearly cumulative calculation on your measure formulas, right? If that is the case, you can try to use the following measure formula:

AAP 2021 Acum =
VAR currdate =
    MAX ( 'Tabla Calendario 2'[Fecha] )
RETURN
    CALCULATE (
        [IAAP],
        FILTER (
            ALLSELECTED ( 'Tabla Calendario 2'[Fecha] ),
            YEAR ( 'Tabla Calendario 2'[Fecha] ) = YEAR ( currdate )
                && 'Tabla Calendario 2'[Fecha] <= currdate
        )
    )

If the above does not help, please share some more detial to help us clarify your scenario and test:

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@JoséVP , Assuming PSA is measure a new measures

Cumulative = CALCULATE([PSA],
FILTER(ALLSELECTED('Calendar Table 2'),'Calendar Table 2'[Date] <= max('Calendar Table 2'[Date])))