NEW COLUMN IF Statement

[pbrainard]

I want to create a new column for Site on my IR Table. I want to populate the new Site column based on two values in an existing column, or bring the Site name in from a RELATED table. Thought I'd ask first before going down the rabbit hole.

Will something like this work?:

New Column = IF 'IR Table'[StaffTitle] = "MH Program Manager" THEN "MH", IF 'IR Table'[StaffTitle] = "SA Program Manager" THEN "SA", ELSE 'CASE Table'[Site]

[VahidDM · Accepted solution]

Hi @pbrainard 

Can you please share some sample of your tables in Text format.
BTW, Try this:

New Column =
VAR _A = 'IR Table'[StaffTitle]
RETURN
    SWITCH (
        _A,
        "MH Program Manager", "MH",
        "SA Program Manager", "SA",
        RELATED ( 'CASE Table'[Site] )
    )

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[pbrainard]

Thank you. Perfect.