Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Match values in a column with itself

Hi All,   I have a table with few columns. I want match fields in one column to match with itself and generate output. I can do it easily in Access by creating a copy of table and joining the respe...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , new column in table 2

if(countx(filter(Table, Table[merchant_id] =(Table2[merchant_id]) && Table[Day] =(Table2[Day]) && Table[user_account_id] = (Table2[user_account_id])),Table[id])+0 >1,"Yes","No")

 

Refer the way to move value from one table to another https://www.youtube.com/watch?v=czNHt7UXIe8

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak : Can you help me in understanding the purpose of Table[id])+0 >1? The id is just some random nos.