Solved: Help Me out with This Formula - Page 2

Amit_Jain1 · 12-01-2019 09:51 AM

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

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

View solution in original post