Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

Multiple Condition

HI Everyone , 

I'm poor in Condition Formating. 
I wanna display , If Column DOI  of Code 4223 > 7 " High " & Less than 4 is "POS" Less than 0,5 is " OOS "

If Column DOI of Code 4983 > 2 "High" & Less than 1 is "POS" Less than 0 is "OOS"

Can anyone guide me how to fix such Condition ? 
I have no idea. 
Your prompt response is really much appreciated. 

Thanks with Regards, 
Chanleakna Hang 

Reports

7 Replies

  • reddobe's avatar
    reddobe
    Regular Visitor
    8 years ago

    Chanleakna,

    Have you tried Edit Queries, Add Column - Conditional Column.

    Add the criteria you stated above and it should work.

    Steve F.

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy
      8 years ago

      reddobe hi , Yes i tried, but the condition in BI is not enough and this is multiple condition with different value in one column. 
      thx 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Chanleakna123,

     

    You can create a calculated column: 

     

    Column = SWITCH(TRUE(),Table1[Code]=4223 && 'Table1'[DOI]>7,"High",Table1[Code]=4223 && Table1[DOI]<4,"POS",Table1[Code]=4223 && Table1[DOI]<0.5,"OOS",'Table1'[Code]=4983 && Table1[DOI]>2,"High",Table1[Code]=4983 && Table1[DOI]<1,"POS",Table1[Code]=4983 && Table1[DOI]<0,"OOS")

     

     See attached pbix file. 

     

    Best Regards,
    Qiuyun Yu

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        8 years ago

        Hi Chanleakna123,

         

        Take the example of the first condition, in your sample data doesn't have record meet the condition when Code is 4223 and DOI >7. You can check the condition one by one and compare to your sample data. 

         

        Best Regards,
        Qiuyun Yu