Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Calculated column if error

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...
Need Help
  • MNedix's avatar
    MNedix
    1 year ago

    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,

MNedix's avatar
MNedix
Solution Sage
1 year ago

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")