New column by comining two columns from two different data sets?

[Kristofferaabo]

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:

[Seth_C_Bauer]

@Kristofferaabo Another option is to use Concatenate

Combine = CONCATENATE(RELATED(facility_contacts[Lastname]), ", " & 'Facilities'[country])

[Kristofferaabo]

@Seth_C_Bauer 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

[tringuyenminh92 · Accepted solution]

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