Forum Discussion
Create new column in table
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 |
Anonymous
is this what you want?
Column = if(CALCULATE(COUNTROWS(Table2),FILTER('Table2',Table2[Name]=EARLIER(Table2[Name])&&Table2[Selected]="Yes"))>0,"Yes","No")
3 Replies
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
you are welcome, && is the same as AND in excel and || is the same as OR in excel.