Scoring text

[geoffgarcia]

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 based fruit field doesn't return as an option.

My thought was something simple like:

If(table[fruit]="Apple") then 1

Else If(table[fruit]="Banana") then 2

Else If(table[fruit]="Cherry") then 3

How can I do something like this?

Thanks,
Geoff

[harshnathani]

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

[az38 · Accepted solution]

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
)