Forum Discussion

Edmi8's avatar
Edmi8
New Member
4 years ago
Solved

LookUpValue with filter

Hello everyone I am trying to create a new column with LookUpValue, but I need it to search under certain condition I am using this function: Cosecha 20220718 = LOOKUPVALUE('Modelo PY'[Fecha ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Edmi8 ,

    You can create a calculated column as below in the table 'Maestro clientes':

    Cosecha 20220718 =
CALCULATE (
    MAX ( 'Modelo PY'[Fecha Cosecha] ),
    FILTER (
        'Modelo PY',
        'Modelo PY'[cliente_id] = 'Maestro clientes'[cliente_id]
            && 'Modelo PY'[Fecha Cosecha] = "20220718"
    )
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Edmi8 ,

You can create a calculated column as below in the table 'Maestro clientes':

Cosecha 20220718 =
CALCULATE (
    MAX ( 'Modelo PY'[Fecha Cosecha] ),
    FILTER (
        'Modelo PY',
        'Modelo PY'[cliente_id] = 'Maestro clientes'[cliente_id]
            && 'Modelo PY'[Fecha Cosecha] = "20220718"
    )
)

Best Regards