Forum Discussion
New Column IF DAX
Hi all, I want to create a new column called 'Department' using DAX. If 'Export Jobs.JobType' = Permanent then 'Permanent' If Team = Permanent then 'Permanent' If Team = London t...
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?
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"
)