Forum Discussion
Error: LOOK UP VALUE does not support comparing values
Hi all, I found the above error when trying to create a calculated column using the LOOKUPVALUE function. So I have the following tables; Table A ID AMOUNT Decription Co...
Hi,
I am not sure if I understood your question correctly, but please try the below calculated column.
I think AMOUNT has to be the first argument in the LOOKUPVALUE function.
AMOUNT DIFF CC =
VAR tab1 =
LOOKUPVALUE ( 'Table A'[AMOUNT], 'Table A'[ID], 'Table C'[ID] )
VAR tab2 =
LOOKUPVALUE ( 'Table B'[AMOUNT], 'Table b'[ID], 'Table C'[ID] )
RETURN
tab2 - tab1
Hi,
I am not sure if I understood your question correctly, but please try the below calculated column.
I think AMOUNT has to be the first argument in the LOOKUPVALUE function.
AMOUNT DIFF CC =
VAR tab1 =
LOOKUPVALUE ( 'Table A'[AMOUNT], 'Table A'[ID], 'Table C'[ID] )
VAR tab2 =
LOOKUPVALUE ( 'Table B'[AMOUNT], 'Table b'[ID], 'Table C'[ID] )
RETURN
tab2 - tab1
Worked successfully, Thanks @Jihwan_kin