Something more practical than an IF Statement

Hi J_o_n_a_s ,

If different employees change department on different dates, I think it is necessary to compare date for each employee but you can try to optimize the formula, for example, using switch() function, using variables, like this:

Column =
VAR date1 =
    DATE ( 2020, 12, 31 )
VAR date2 =
    DATE ( 2020, 5, 8 )
VAR new = [Employee] & 2
RETURN
    SWITCH (
        [Employee],
        "Jonas", IF ( [Date] > date1, new, [Employee] ),
        "A",
            IF ( [Date] > date2, new & 2, [Employee] )
    )

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.