I have a column of data (Column A) that has multiple values within it (Classifications) separated only by commas. I only need some of those values to be considered (List of Specific Classifications) for my new column (Column B). I am unfamiliar with Dax and need help with the language.
I need to create a column that will follow this logic:
Column B = if (Column A) contains 2 different values from (List of Specific Classifications), then Y, else N.
Is this possible with Dax? Could someone please point me in the right direction?