Trying to figure out how to do an IF/OR case for three columns

[suchomelb]

I was able to do this easily with two columns, but now I have three separate sources that I want to determine the different types of matching across the columns. I want to use the results as a slicer essentially so I can filter in my report. 

Here is an example set of what i'm trying to accomplish:

Basically depending on the criteria it meets if its in one or more columns I want to give it a description like in my Preferred Output example above.

Thanks ahead of time for any and all help! 

[Greg_Deckler · Accepted solution]

@suchomelb Try:

Column = 
  SWITCH( TRUE(),
    [A] <> BLANK() && [B] <> BLANK() && [C] <> BLANK(), "In All",
    [B] = BLANK() && [C] = BLANK(), "Not in B or C",
    [A] = BLANK() && [B] = BLANK(), "Not in A or B",
    [C] = BLANK(), "Not in C",
    [A] = BLANK(), "Not in A",
    BLANK()
  )

[suchomelb]

This worked perfect for me. I'm still trying to wrap my head around how it all works but i'm just glad there's people out there like you that do so I can learn it from somebody. I havn't used Power BI for more than six months or so and the DAX seems way more difficult to learn than excel formulas were.  Thanks again!

[Syk]

You can use a custom column to compare multiple values. It doesn't have a gui to help out but the logic should be pretty simple to follow. Check out this post which has an example using dates.
Solved: Power query If submit date between start date and ... - Microsoft Power BI Community