Forum Discussion

Juanpablocl's avatar
Juanpablocl
Frequent Visitor
3 years ago
Solved

Help with a calculated column

How could I accomplish this "Fuerza en kneepoint" with a calculated column?  I need a calculated column that gives me the value of "Fuerza" where "both "Delta and "Kneepoint" are equal for eve...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Juanpablocl 

    try like:

    Fuerza en kneepoint=
    MAXX(
    FILTER(
    data,
    data[Nivel]=EARLIER(data[Nivel])&&[Delta]=[Kneepoint]
    ),
    data[Fuerza]
    )

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Juanpablocl 

try like:

Fuerza en kneepoint=
MAXX(
FILTER(
data,
data[Nivel]=EARLIER(data[Nivel])&&[Delta]=[Kneepoint]
),
data[Fuerza]
)