If statement in chart expression

[cjett7769]

I and looking to create a if statement in a chart expressio. For example

if status = 1 then given

if status =2 then refused.

I Am trying to find a way to make this all one statement.

[vishsaggi]

May be this?

= Pick(Match(status, 1, 2), 'Given', 'Refused')

[sunny_talwar · Accepted solution]

This should be enough

Pick(status, 'Given', 'Refused')

Because match will also assign 1, 2 value to status which is its value already

[vishsaggi]

Yeah, you are right. Got it.