Create new column in table

[Anonymous]

Hi everyone, trying to add a new column to a table and populate it with yes or no based on the data from the selected column. 

There are many duplicates in the name column and if any of the names have a yes in the selected column I want a yes to be populated in all cells in the new column. 

For examble Apple appears 3 times in name column with 2 yes and 1 no in selected column, in the new column I want to see all entries for apple say yes. 

Grape appears 2 times in name column with 0 yes and 2 no in selected column, in the new column I want to see all entries for grape say no. 

Name	Selected	New column
Apple	Yes
Banana	Yes
Grape	No
Apple	No
Apple	Yes
Banana	No
Grape	No

[ryan_mayu · Accepted solution]

@Anonymous 

is this what you want?

Column = if(CALCULATE(COUNTROWS(Table2),FILTER('Table2',Table2[Name]=EARLIER(Table2[Name])&&Table2[Selected]="Yes"))>0,"Yes","No")

[Anonymous]

Hi ryan_mayu, thank you so much for your help this is exactly what I wanted!!

I don't understan the double && but it works 🙂

[ryan_mayu]

@Anonymous 

you are welcome, && is the same as AND in excel and || is the same as OR in excel.