Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

From the data you posted, your Team column is enought to achive the expected results as it has all the three entries and ExportJobs.Jobtype is anyways permanant for permamant values in Team. 

 

If so, you can use this : 

Department =
SWITCH('Table'[Team],"London", "Tech and Prof","North","Tech and Prof","Permanant","Permanant")

 

Not sure, if there is a case where you have Permanant under Team and someother value in Jobtype. if there is a case like this you can use this 

Department =
SWITCH('Table'[Team],"London", "Tech and Prof","North","Tech and Prof",
If('Table'[Team] = "Permanant" && 'Table'[ExportJobs.JobType] = "Permanant","Permanant"))
 
If my response helped you please like and accept this as a solution.

 

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago

Hi Anonymous 

 

there are some cases where Export Jobs.Job Type = Permanent but the Team may not be Permanent

 

How do I make the Department = Permanent if Export Jobs.Job Type = Permanent and the rest relate to Team?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    From your input, i understand that if export.Jobtypes is Permanant then it should be permanant else it should depend on team values.

     

    you can use below

     

    Department =

    IF('Table'[ExportJobs.JobType] = "Permanant" && 'Table'[Team] <> "Permanant",
    SWITCH('Table'[Team],"London", "Tech and Prof","North","Tech and Prof"), "Permanant"
    )