Forum Discussion

J_o_n_a_s's avatar
J_o_n_a_s
Icon for Helper I rankHelper I
5 years ago
Solved

Something more practical than an IF Statement

Hi everyone,    So i need to come up with a solution for when an employee changes department. The work hours of this employee from a certain date onwards have to be saved under the new department w...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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.

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
5 years ago

J_o_n_a_s 

Tyring to understand the final objective .Should you create the data in a column only? What do you want to achieve as report , can you please share that as a snapshot?

  • J_o_n_a_s's avatar
    J_o_n_a_s
    Icon for Helper I rankHelper I
    5 years ago

    Yeah preferably in a column.

     

    Basically the same result as what I got but in a more practical way for when more employees change department on different dates. I need to do this for past data as well so there will be several department changes.