Hey Team,

I am curious as to what function would be best to re-categorize Regions in an Excel Table so PowerBI (Bing Maps) will recognize it by region.

I need to convert the following:

If EMEA then = Europe
If AP then = Asia
If LAR then = South America
If NAR then North America
If Other then = Other

regionname.PNG



Any help would be appreciated!