Using Switch

[hesschief]

I am trying to add a new measure to a table and using data from another column to standardize some fields.

This is what I have an keep getting errors

Status = SWITCH(FRAM[elgibility},'Free', "Free",'Reduced', "Reduced",'Paid')

TIA

[Chanty4u · Accepted solution]

Try this 

Status =

SWITCH(

    FRAM[eligibility],

    "Free", "Free",

    "Reduced", "Reduced",

    "Paid", "Paid",

    "Other" -- optional default value

)