Forum Discussion

Shruthi96's avatar
Shruthi96
Helper III
4 years ago
Solved

Help DAX command - If else statement

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 -...
  • SpartaBI's avatar
    4 years ago

    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