Column with multiple nested ifs

[Alisea_MI]

Hi,

I am new to Dax and would appreciate help with writing a formula for a calculated column that returns the result in the column "EWS/Pack" in the table below.

The conditions are following:

IF [SampleSubTypeIDCode] contains text "Pack" AND [u_axflag] is "Null" or "N", expected outcome "Pack+N" else "Pack + Y",

IF [SampleSubTypeIDCode] contains text "EWS" AND [u_axflag] is "Null" or "N", expected outcome "EWS+N" else "EWS+ Y",

Else [SampleSubTypeIDCode]

Thank you so much in advance!

[Alisea_MI]

Many thanks, @amitchandak ! Works perfect!

[amitchandak · Accepted solution]

@Alisea_MI , You can not have 2 else to in if. So rethink on condition

I attempted like this a new column

Switch( True() ,
search("Pack",[SampleSubTypeIDCode],,0) >0 && (Isblank([u_axflag]) || [u_axflag] = "N") , "Pack+N" ,
search("Pack",[SampleSubTypeIDCode],,0) >0 , "Pack + Y" ,
search("EWS",[SampleSubTypeIDCode],,0) >0 && (Isblank([u_axflag]) || [u_axflag] = "N") , "EWS+N" ,
search("EWS",[SampleSubTypeIDCode],,0) >0 , "EWS+ Y" ,
[SampleSubTypeIDCode])