Forum Discussion
Helper IICreating a geographical hierarchy : Continent > Country
adrien5555 Actually there is an easy way. I replicated your scenario with Actual table (with values) and a table wth continents and countries (lookup table) and loaded it into powerbi desktop.
Go to query editor -> select values table -> Merge queries -> select matching columns from both table (countries column) -> left outer as join kind -> OK.
This will give you matching Continent from the lookup table
Helper IIankitpatira : thx, really see the point here. Got a new dataset with continents and countries.
Creating a Lookupvalue is a bit too much for me at this point... Any help very much appreciated.
Is it like :
IF (country in dataset1 match country in dataset2) THEN (Field value is equals to corresponding value //continent// in dataset2)
?
Tried to create a relationship between other dataset with a 'country' field, but I got this :
Community Championadrien5555 Actually there is an easy way. I replicated your scenario with Actual table (with values) and a table wth continents and countries (lookup table) and loaded it into powerbi desktop.
Go to query editor -> select values table -> Merge queries -> select matching columns from both table (countries column) -> left outer as join kind -> OK.
This will give you matching Continent from the lookup table
- adrien5555
ankitpatira: So cool thanks so much !
Having another problem to refresh the dataset, but the preview in the Query Editor looks just perfect.
thanks !