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 HenryJS
try a new column with SWITCH()
Department = SWITCH(TRUE(),
[Export Jobs.JobType] = "Permanent", "Permanent",
[Team] = "Permanent", "Permanent",
[Team] = "London", "Technical & Professional",
[Team] = "North", "Technical & Professional",
"Undefined"
)do not hesitate to give a kudo to useful posts and mark solutions as solution