 # Help Me out with This Formula

This Is My Present Formula in Virtual Column

SELECT(Data[Key],AND([Material]=[_THISROW].[Material],[Date]=[_THISROW].[Date]))

I want to Add OR Condition in This Expression For Filtered View

IF Column [Order Status] = “Yes” Then Filter Column Having “Yes” Value from Table Data([Order Given] Column

IF Column [Order Status] = “No” Then Filter Column Having “No” Value from Table Data([Order Given] Column

IF Column [Order Status] = Blank Then Filter Column Having Both “Yes” and “No” Value from Table Data([Order Given] Column

Column Type
Data Table [Order Given]= Enum
Current Table [Order Status] = Enum

Any Idea How to Achieve This Result

@Amit_Jain
Try with this:

``````SWITCH(
[Order Status],
"Yes", SELECT(Data[Key],AND([Material]=[_THISROW].[Material],[Date]=[_THISROW].[Date],[Order Given]="Yes")),
"No", SELECT(Data[Key],AND([Material]=[_THISROW].[Material],[Date]=[_THISROW].[Date],[Order Given]="No")),
SELECT(Data[Key],AND([Material]=[_THISROW].[Material],[Date]=[_THISROW].[Date],ISNOTBLANK([Order Given])))
)
``````

No Sir Didn’t Get Desired Result

@Amit_Jain
What ENUM values you have in your [Order Status] & [Order Given] columns?

Oops!
It’s was Right Solution
There was error from My Side
Thanks @LeventK

Let Me Know if there is Another Simple way as I am Having More Then 10 Variations Value in That Column with This Method the Formula will be Too Lengthy

You’re welcome @Amit_Jain