Forum Discussion

geoffgarcia's avatar
geoffgarcia
Helper I
6 years ago
Solved

Scoring text

I have a column of types of fruit and want to add a score for each (Apple = 1, Banana = 2, Cherry = 3, etc.).   I've tried to create a measure thinking I could use an IF condition, but my text base...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi geoffgarcia 

    it's better to create a column with SWITCH() like

    Column = 
SWITCH(table[fruit],
"Apple", 1,
"Banana", 2,
"Cherry", 3,
0
)

    but if you still need a measure try

    Column = 
var _fruit = MAX(table[fruit])

RETURN

SWITCH(_fruit,
"Apple", 1,
"Banana", 2,
"Cherry", 3,
0
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi geoffgarcia ,

 

Create a Calculated COlumn

 

Concept Stage Status =
SWITCH (
    TRUE (),
    table[fruit] = "Apple", 1,
    table[fruit] = "Banana", 2,
    table[fruit] = "Cherry", 3,
    BLANK ()
)

 

Regards,

Harsh Nathani