Multi Condition Statement to Set a Variable

Question

I am looking to create a variable called DIFF that is set to a specific number based on the value of a text string called STATUS. Basically -

If STATUS=Submitted then DIFF=14

or

If STATUS=Active then DIFF=21

or

If STATUS=OnHold then DIFF=28

What would be the syntax for this? Thanks in advance.

deku · Accepted Answer

Var diff =Switch(&nbsp;Selectedvalue( table[status] ),"Submitted", 14,"Active", 21,"On hold", 28)&nbsp;

Forum Discussion