Help Me out with This Formula

[Amit_Jain1]

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

[LeventK · Accepted solution]

@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])))
)

[Amit_Jain1]

No Sir Didn’t Get Desired Result

[LeventK]

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

[Amit_Jain1]

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

[LeventK]

You’re welcome @Amit_Jain