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

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
)

2 Replies

  • az38's avatar
    az38
    Community Champion
    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