question on DAX

[Anonymous]

Hi BPI users, 

I have a question on Dax, I have column contains 7 product names and I want to create a Y/N column where Y = all the 7 product names and N = include  all except one product name . Is there a switch function we can use in DAX to do that 

[ryan_mayu]

@Anonymous 

Do you want to use this in the filter or calculation?

could you pls provide the sample data and expected output?

[Anonymous]

I want to use that in a filter 

the total products I have is 

My expected output for Y is all the 7 products together and N should have all the 6 products except the one which is left out.

[ryan_mayu]

@Anonymous 

pls see the attachment to check if this is what you want

[Anonymous]

Hi Greg, 

The formula you suggested gives me Y= all 7 product and N= only one product.  but I want for N = all product 6 except one. This is where I am stuck 

[Greg_Deckler]

@Anonymous Sure:

Column = 
  SWITCH([Product],
    "Product No","N",
    "Y"
  )