Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combining 2 columns from 2 different tables into one column

Hi All, Please kindly can you help! I have 2 tables as showing below  Table 1 name = "TableA" DLL Business Unit Opportunity Name/ FO Application # Customer Name Account Name (Originator) F...
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    It seems that you are missing a ")"that will occur such error:

     

    I tested again and the function works fine.

     

    Here is a sample .pbix file you can refer to.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
     
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

Yes, you would do this in Power Query using a Cartesian Join, but I'll need good data to play with. See the links below. I cannot use what you pasted in because it is not in a table format and I'll spend more time cleaning up random spaces and special char 160 spaces than actually working on the problem.

 

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum