cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Chanleakna123 Post Prodigy
Post Prodigy

Multiple Condition

1st.PNG

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 

7 REPLIES 7
reddobe
Regular Visitor

Re: Multiple Condition

Chanleakna,

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

Add the criteria you stated above and it should work.

Steve F.

Moderator v-qiuyu-msft
Moderator

Re: Multiple Condition

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Chanleakna123 Post Prodigy
Post Prodigy

Re: Multiple Condition

@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 

Chanleakna123 Post Prodigy
Post Prodigy

Re: Multiple Condition

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

Moderator v-qiuyu-msft
Moderator

Re: Multiple Condition

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Chanleakna123 Post Prodigy
Post Prodigy

Re: Multiple Condition

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.
Moderator v-qiuyu-msft
Moderator

Re: Multiple Condition

Hi @Chanleakna123,

 

You can update the calculated column like below: 

 

Column = SWITCH(TRUE(),(Table1[Code]=4223 || Table1[Code]=4879) && 'Table1'[DOI]>7,"High",(Table1[Code]=4223 || Table1[Code]=4879) && Table1[DOI]<4,"POS",(Table1[Code]=4223 || Table1[Code]=4879) && 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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors