Forum Discussion
HenryJS
Post Prodigy
Post ProdigyNew 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...
FrankAT
Community Champion
Community ChampionHi,
Department =
IF(Tablename[Export Jobs.JobType] = "Permanent" ; "Permanent";
IF(Tablename[Team] = "Permanent" ; "Permanent";
IF(Tablename[Team] = "London" ; "Technical & Professional";
IF(Tablename[Team] = "North" ; "Technical & Professional" ))))
Regards FrankAT