Forum Discussion
Solved
Medida con error
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(...
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
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