Forum Discussion
create a custom 2 column table/list with the first column listing all the countries I want to edit
Hello, I have a column with a list of various countries. I want to replace all values with their continents instead. So for example, Spain and Greece will be replaced with Europe, Canada and Mexico will be replaced with North America... and so on. I found this function, https://docs.microsoft.com/en-us/powerquery-m/list-replacematchingitems But I was wondering instead of writing out all the countries in a continent and manually writing all that syntax for each country, if instead there is a way I can create a custom 2 column table/list with the first column listing all the countries I want to edit, and the 2nd column being the new value I want to change to (continent). I feel like this is simple to do, but as a new powerbi user, im having a hard time with it
paulality No need to replace anything, make a table with countries and corresponding continents, then make a relationship from countries to your table countries.