Forum Discussion

srobs's avatar
srobs
Frequent Visitor
2 years ago
Solved

Multiple IF/AND for text fields

Hi, I'm pretty new to Power BI and not sure exactly what I can/can't do.    I have quite a big data set of impoterd JIRA defect tickets, 2 of the columns are "Defect Occurance" and "Defect Severity...
  • srobs's avatar
    srobs
    2 years ago

    Turned I had a couple of issues! 

    1. I needed to select "new column" not "new measure" in order to pull from my data

    2. I had left a comma at the end

    3. I spelt severity wrong and had copy pasted it (duh)

     

    In the end it looked like this, but with all 16 variables, and it worked 🙂

    Column =
    SWITCH(
        true(),
        [Defect Severity]="low"&&[Defect Occurrence]="low","Acceptable",
        [Defect Severity]="Low"&&[Defect Occurrence]="Medium","Acceptable"
    )
srobs's avatar
srobs
Frequent Visitor
2 years ago

Turned I had a couple of issues! 

1. I needed to select "new column" not "new measure" in order to pull from my data

2. I had left a comma at the end

3. I spelt severity wrong and had copy pasted it (duh)

 

In the end it looked like this, but with all 16 variables, and it worked 🙂

Column =
SWITCH(
    true(),
    [Defect Severity]="low"&&[Defect Occurrence]="low","Acceptable",
    [Defect Severity]="Low"&&[Defect Occurrence]="Medium","Acceptable"
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi srobs ,

     

    Could you tell me if your issue has been resolved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your issue or share me with your pbix file without sensitive data.


    Best Regards,

    Rico Zhou