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 "Hi...
Reports
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

  • Chanleakna123's avatar
    Chanleakna123
    Post Prodigy
    8 years ago

    v-qiuyu-msft HI , i had used your file and see the formula but in the column shown nothing 

    • 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

      • Chanleakna123's avatar
        Chanleakna123
        Post Prodigy
        8 years ago
        Hi dear ,
        If 4223 and 4879 have the same condition, what should I add in the dax condition formula ? It’s about “ ... =4233,4879 && .... ? Connected this 2 something like this ? Your response is so much appreciated.