Help DAX command - If else statement

[Shruthi96]

Hi Team , 

Need Help 

I am looking for the Dax column formula, where I have 3 work types and 2 products:
Product A : It should pull all the rows
For Product B :
                        Feature - It should pull all the rows
                        Bug Fix - It should pull all the rows
                        For Enhancement - It should pull only the rows which as "a11y" anywhere in the description column.

Many thanks 

[Shruthi96]

Thanks @SpartaBI 

[Shruthi96]

Thanks @SpartaBI  for replying. Formula should look for Product also. 

[SpartaBI]

@Shruthi96 oh ye, missed that. I edited the furmula in the original message

[SpartaBI · Accepted solution]

@Shruthi96 

Required_Output_Column = 
SWITCH(
	TRUE(),
        'Table'[Product] = "A", "Y",
	'Table'[Work Type] IN {"Feature", "Bug Fix" }, "Y",
	SEARCH("a11y", 'Table'[Description], 1, 0 ) >=1 , "Y",
	"N"
)

Showcase Report – Contoso By SpartaBI