Multiple conditions

I want to create a conditional custom in Power Query: I have given the sample data and expected output: Month (text)    Emp id        Segment         Segment Transfer(Expected Output) 2023 01 ...