Forum Discussion
Need yes or no based on two different columns
Hi,
I'm having a table with thousands of entries.By default I'm having ID, Item, Identity columns. If any one item has identity yes then all the item which belongs to that perticular ID must have result yes and all the items has no then the result for that perticular id must be no. So, there are few Id's with only sigle items and others with multiple items. So, I need a fuction or DAX Code to get the output in Result column. Sample table is provided below.
Please help me.
Thanks
| ID | ITEM | Identity | Result |
| abcd | 1 | no | yes |
| abcd | 2 | yes | yes |
| abcd | 3 | no | yes |
| acb | 1 | no | no |
| acb | 2 | no | no |
| aec | 1 | no | no |
| ahg | 3 | yes | yes |
- Result Column =
IF("yes" IN SELECTCOLUMNS(FILTER('Table',[ID] = EARLIER([ID])),"Result",[Result]),"yes","no")
2 Replies
- Greg_Deckler
Community Champion
Result Column =
IF("yes" IN SELECTCOLUMNS(FILTER('Table',[ID] = EARLIER([ID])),"Result",[Result]),"yes","no")