Forum Discussion

kbraga's avatar
kbraga
Helper I
6 years ago
Solved

Calculated Column with nesting IF, THEN statements

I think this is real simple but I can't seem to figure it out. I have one column with a list of text values and based on those values, I want a certin numeric value to appear in a new calculated colu...
Need Help
Tips and Tricks
  • kbraga's avatar
    kbraga
    6 years ago

    Found a solution:

     

    Likert Sort Value =
    SWITCH (
    TRUE (),
    'Survey Response'[Text] = "Strongly Disagree", "1",
    'Survey Response'[Text] = "Disagree", "2",
    'Survey Response'[Text] = "Neutral", "3",
    'Survey Response'[Text] = "Agree", "4",
    'Survey Response'[Text] = "Strongly Agree", "5",
    'Survey Response'[Text] = "NA", "6",
    "0"
    )
az38's avatar
az38
Community Champion
6 years ago

Hi kbraga 

If I understand you correct try SWITCH, like

Associated Value = 
SWITCH(Table[Likert Scale],
"Strongly Disagree", 1,
"Disagree", 2,
"Neutral", 3,
"Agree", 4,
"Strongly Agree", 5,
6
)