Singling out certain text values in dax- birthday money

[bonjourposte]

I've got a column of about 20 people and their birthdays, and I'm creating a DAX measure specifically for the nieces and nephews who will get money for their birthday.  Every birthday, they will get $5 plus their age.  

I'm trying to say, IF [person] = "tanya", "bobby", "sarah", "troy", then [Current Age] + $5.  How do you write that in DAX?  Is that a switch statement?  

Thanks!

[bonjourposte · Accepted solution]

Thanks so much for your responses, guys.  I ended up using a SWITCH statement: 

Birthday Money =

    SWITCH(

        MAX(

    'Important Birthdays'[Person]),

    "Tanya", MAXX('Important Birthdays',[AgeToBeThisYear]) + 5,

    "Bobby", MAXX('Important Birthdays', [AgeToBeThisYear]) +5,

    "Sarah", MAXX('Important Birthdays', [AgeToBeThisYear]) +5,

    "Troy", MAXX('Important Birthdays', [AgeToBeThisYear]) +5,

    0

    )

[Ritaf1983]

Hi @bonjourposte 
If the goal is a calculated column you can use this formula :

Column = IF([name] in {"tanya", "bobby", "sarah", "troy"},[age]+5,[age])

If you need the measure :

Measure_ =

SUMX(

    SUMMARIZE(

        'Table',

        'Table'[name],

        "Sum",

        IF(

            'Table'[name] IN {"tanya", "bobby", "sarah", "troy"},

            SUM('Table'[age]) + 5,

            SUM('Table'[age])

        )

    ),

    [Sum]

)

Pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Shravan133]

try this:

Birthday Amount =
VAR PersonList = {"tanya", "bobby", "sarah", "troy"}
VAR CurrentAge = [Current Age] -- Replace [Current Age] with your actual column name

RETURN
IF (
[Person] IN PersonList,
CurrentAge + 5,
BLANK() -- This will return blank if the person is not in the list
)