Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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

     

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

think it's better to create relationships between these tables by ID

then put the ID columns of Table C on the row, and create a measure

Amount Diff=sum(tableA[Amount)]-sum(TableB[Amount])