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...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous try this in a calculated column

= CONCATENATEX(FILTER(Table,Table[Filed1]=EARLIER(Table[Filed1])),Table.[Filed2],",")

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi wdx223_Daniel wdx223

  

Thanks for your reply. PLease see below screen shot. I want to match the 3 fields and add a column in one of the the tables and update it with Yes or No.