Forum Discussion

Helper V

3 years ago

Using two columns in Switch Function

Hello, I was hoping someone could help me please I have a Switch function something like this : 'Mytable'[Stuff] = "ddd" , "Dave" , 'Mytable'[Stuff] = "sss" , "Sarah" , 'Mytable'[Stuff] = "k...

Solution Supplier

3 years ago

I think you could use the AND() function. Try someting like the following measure:

Measure =
  SWITCH(
    TRUE(),
    AND( Mytable[Stuff] = "mll", Mytable[SubStuff] = "DIVmll" ), "VLAD",
    AND( Mytable[Stuff] = "sss", Mytable[SubStuff] = "DIVsss" ), "VLAD"
  )

If I answered your question, please mark my post as a solution.

Best,

Helper V

3 years ago

Alf94 thank you for taking the time to reply.

Just to check , Can I carry on the rest of the switch with normal conditions? For example, if my table[stuff] equals mll but [substuff] doesnt, then switch mll to something else?

Alf94
Solution Supplier
3 years ago
Pricey79I am not sure what you mean by "switch mll to something else".

You can write different types of conditions in your switch statement:

Measure = SWITCH( TRUE(), AND( Mytable[Stuff] = "mll", Mytable[SubStuff] = "DIVmll" ), "VLAD 1", AND( Mytable[Stuff] = "sss", Mytable[SubStuff] = "DIVsss" ), "VLAD 1", Mytable[Stuff] = "mll", "VLAD 2", AND( Mytable[Stuff] = "mll", Mytable[SubStuff] <> "mll" ), "VLAD 3", OR( Mytable[Stuff] = "ddd", Mytable[Substuff] = "DIVddd" ), "VLAD 4" )
where the "<>" symbol means "not equal".

Let me know if this answers your question.
- Pricey79
  Helper V
  3 years ago
  Alf94 thanks for your time again. Let me see if I can explain it better
  
  In the data there is a column called Name and its entires look something like this:
  
  AAA - MLL- Answer
  AAA- MLL - Correct
  AAA- SSS- Answer
  
  I have this split this colummn by delimiter using the - and just left the column as the middle characters (MLL, SSS etc)
  This is now called stuff. The switch then says if stuff is MLL then called it Mo , if SSS then Sarah.
  The other column called Substuff has the original data in so :
  AAA - MLL- Answer
  AAA- MLL - Correct
  AAA- SSS- Answer
  I want to add to the switch that if this column has "Answer" in it, regardless of the MLL or SSS, then call it VLAD
  
  Does that help?
  
  Thank you