Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

question on DAX

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 . ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Sure:

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