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

3 Replies

  • MNedix's avatar
    MNedix
    Solution Sage
    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,

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Mnedix dose not give the expected result

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