Calculated column if error

[blestone111]

Hi Experts

trying to write the following if statement and as calculated column, but its not working as expected..

FLAGS = IF('ORANGE (FACT)'[CSA_FLAG] = "Y" && 'ORANGE (FACT)'[CSE_FLAG] = "Y", "CSA and CSE",
                IF('ORANGE (FACT)'[CSE_FLAG] = "Y" && 'ORANGE (FACT)'[CSE_FLAG] = "N", "CSA Only",
                IF('ORANGE (FACT)'[CSE_FLAG] = "N" && 'ORNAGE (FACT)'[CSE_FLAG] = "Y", "CSE Only","")))

[MNedix]

Yes, because I copied your typos 🙂 You use the same CSE_FLAG in the 2nd and 3rd arguments.

Corrected below:

Flags (forum) =
SWITCH (
	True (),
	'ORANGE (FACT)'[CSA_FLAG] = "Y" && 'ORANGE (FACT)'[CSE_FLAG] = "Y", "CSA and CSE",
    'ORANGE (FACT)'[CSA_FLAG] = "Y" && 'ORANGE (FACT)'[CSE_FLAG] = "N", "CSA Only",
    'ORANGE (FACT)'[CSA_FLAG] = "N" && 'ORNAGE (FACT)'[CSE_FLAG] = "Y", "CSE Only")

[MNedix · Accepted solution]

Hi,

Use the Switch function and re-write your formula as below:

Flags (forum) =
SWITCH (
	True (),
	'ORANGE (FACT)'[CSA_FLAG] = "Y" && 'ORANGE (FACT)'[CSE_FLAG] = "Y", "CSA and CSE",
    'ORANGE (FACT)'[CSE_FLAG] = "Y" && 'ORANGE (FACT)'[CSE_FLAG] = "N", "CSA Only",
    'ORANGE (FACT)'[CSE_FLAG] = "N" && 'ORNAGE (FACT)'[CSE_FLAG] = "Y", "CSE Only")

If this solved your problem then please mark it as the solution so others can see it.

Best,

[blestone111]

Hi Mnedix dose not give the expected result