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

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

CalculatedColumn=MAXX(FILTER(Table,Table[Nivel]=EARLIER(Table[Nivel])&&Table[Delta]=Table[Kneepoint]),Table[Fuerza])