Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error with LOOKUPVALUE

Hello

 

I want to create a calculated column where the value of Col1 exists in Col2.

 

I wrote this calculated column but it does not work:

 

Column = IF(LOOKUPVALUE(Table1[Col2],Table1[Col2],Table1[Col1])="","Not present")
 
Any advice?
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , Try like

    if(countx(filter(Table, [col1] = earlier([col2])),[col1])>0,"Present","Not present")

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    The data is in the same table, could you share a screenshot of it?

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    HI  Anonymous 

    For your case, try this simple formula

    Column 2 = IF(Table1[Col1] IN VALUES(Table1[Col2]),"present","Not present")

     

    Result:

     

    Regards,

    Lin