Forum Discussion
New column by comining two columns from two different data sets?
Hi,
I have two simple datasets, and I want to combine two coloums from each table.
For instance:
Lastname in the facility_contacts
and
Country in the facilities
In excel I would do: =lastname&country, but thuis doesn't seem to be possible accross the datasets.
They are linked...
I have made a screenshot below:
Hi Kristofferaabo,
Please use Related method:
combine = Sheet1[name] & RELATED(Sheet2[last])
If this works for you please accept it as solution and also like to give KUDOS.
Best regards
Tri Nguyen
3 Replies
Hi Kristofferaabo,
Please use Related method:
combine = Sheet1[name] & RELATED(Sheet2[last])
If this works for you please accept it as solution and also like to give KUDOS.
Best regards
Tri NguyenKristofferaabo Another option is to use Concatenate
Combine = CONCATENATE(RELATED(facility_contacts[Lastname]), ", " & 'Facilities'[country])
Anonymous and tringuyenminh92 thanks both for great suggestions both were exactly what I needed.. you just boosted my POwerBI knowledge with 100% thanks for this :)
Happy friday
Kristoffer
