Forum Discussion

JoséVP's avatar
JoséVP
New Member
4 years ago
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(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]))))
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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])))

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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