Forum Discussion
Multiple IF Statements (50+)
Hello everyone, i have a cloumn full of abbrevations, i need to create a new column with full name (eg. COUNTRY NAME = IF(Table1[Noc] = "FRA", "France",IF(Table1[Noc] = "GER", "Germany",.... T...
Put your data in a table and use a merge to match the short codes. You can return the country full name after that.
For that many, you almost certainly want to use a table as HotChilli recommends.
I just wanted to mention the SWITCH function which is much cleaner than IF in these sorts of situations:
Country Name = SWITCH ( Table1[Noc], "FRA", "France", "GER", "Germany", "ITA", "Italy", "USA", "United States of America" )
HotChilli sorry i couldn't get it , can you show me a way to do that ? or anyway to make it with DAX