Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 HI , i had used your file and see the formula but in the column shown nothing
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
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
Chanleakna,
Have you tried Edit Queries, Add Column - Conditional Column.
Add the criteria you stated above and it should work.
Steve F.
@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