vlookup

[Anonymous]

Hello 

I need to create a calculated column from other column wich shows certain quantity , when the column "Planta" and the column "Centro_Receptor" exchange positions I need the "cantidad" value in other column

For example for the week 51 form 1024 to 1023 is 166 and form 1023 to 1024 is 424, so the result must be 

0

424

0

166

I need some help please!

[Zubair_Muhammad]

@Anonymous

May be something like this

Column =
VAR VAL =
    LOOKUPVALUE (
        [Cantidad],
        [PLANTA], [CENTRO_RECEPTOR],
        [CENTRO_RECEPTOR], [PLANTA]
    )
RETURN
    IF ( VAL = [Cantidad], 0, VAL )

[Anonymous]

Hello @Zubair_Muhammad 

Thanks for the answer, unfortunatly it didnt worked, i think might be because I have other values in the "Semana" column and in the planta column

Do you think anorther solution?

[v-piga-msft]

Hi @Anonymous,

To get the solution quickly, please share your sample data as table format and your desired output so that we can copy and test on it.

Best Regards,

Cherry