Sales orders that contain apples Y/N
Hi, What is the column or measure formula to generate the Y or N in the 'Does the order contain apples' column? Using a DirectQuery model. OrderID Item Does the order contain apples? 001 Apples Y 001 Brocolli Y 002 Pears Y 002 Apples Y 002 Bananas Y 003 Bananas N 003 Pears N 004 Apples Y Thanks for your help.