Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Icon for Helper IV rankHelper IV
9 years ago
Solved

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: ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Kristofferaabo Another option is to use Concatenate

Combine = CONCATENATE(RELATED(facility_contacts[Lastname]), ", " & 'Facilities'[country])
  • Kristofferaabo's avatar
    Kristofferaabo
    Icon for Helper IV rankHelper IV
    9 years ago

    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