Create a custom column

[ewelinag17]

Dear
I have a table consisting of the production date and the fault.
How to create a Result column in Power BI?

If "yes" in the fault column, the result is: "bad".
If in the fault column is "no" and in the date column: " -", the result: "no exhibit".
If there is "no" in the fault column and there is a date in the "date" column, the result is: "micro".
If there is no information in the fault column, the result: "lack of information".

I got a little lost in it 😞
Thank you in advance for your help.

[Greg_Deckler · Accepted solution]

@ewelinag17 - Use SWITCH(TRUE()...) like this:

result =
  SWITCH(TRUE(),
    [fault] = "yes","bad",
    [fault] = "no" && [date of production] = "-","no exhibit",
    [fault] = "no","micro",
    "lack of information"
  )