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...
Try this:
Department =
IF(
[Export Jobs.JobType] = "Permanent" ; "Permanent" ;
IF(
[Team] = "Permanent" ; "Permanent" ;
IF(
[Team] = "London" ; "Technical & Professional" ;
IF(
[Team] = "North" ; "Technical & Professional" ;
BLANK()
))))
Edit:
Nvm this, the switch is better! 🙂 az38
Hi all,
Thank you
I can't understand why the two totals on the below matrix tables don't add up ? For example it says 338 in the candidate calls total on both but if you add up bottom table it doesn't add up to 338?
I have merged the two tables to bring in Export Jobs.Job Type. Is this what is causing the error?
