Combining 2 columns from 2 different tables into one column

[Sam82]

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)	First Docs In Date/Time	Net NBV	Sales Support Owner	Sales Stage	Sales Sub Stage	Reason for Audit Rejection
Constr. Transp. & Industrial	8.2621E+13	D O Constable Contractor	Ernest Doe & Sons Ltd	25/03/2020 08:43		UK_SPOC_CV_Flow_WIP	4.Accepted	4.5 Clarification on docs	Credit;Fraud Checklist

Table 2 name = "TableB"

BU	Contract No	Date & Time Received	Customer name
Constr. Transp. & Industrial	82621450019119	26/03/2020 10:08	JHD Bowen Building Contractor

Question Please;

- I would like to extract all the data in column "Opportunity Name/ FO Application #" from TableA, and all the data in column "Contract No" in TableB. As you notice there is no direct link between the 2 tables. Is there a solution to pull all the data from the 2 columns in to one column (only distinct value)? Many thanks 

Kind Regards

Sarmad Dra

[v-kelly-msft]

Hi  @Sam82 ,

Create a table using below dax expression:

Table C= UNION(ALL(TableA[Opportunity Name/ FO Application #]) , ALL(TableB[Contract No]) ))

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Sam82]

when I use the following; 

Table C= UNION(ALL(TableA[Opportunity Name/ FO Application #]) , ALL(TableB[Contract No]) ))

I am getting this error "Too few arguments were passed to the UNION function. The minimum argument count for the function is 2."

Do you know whye?

Thank you,

Sam

[amitchandak]

You can create a new table like this

distinct(union(all(TableA[Opportunity Name/ FO Application #]) , all(TableB[Contract No]) ))

[Sam82]

when I use the following; 

distinct(union(all(TableA[Opportunity Name/ FO Application #]) , all(TableB[Contract No]) ))

I am getting this error "Too few arguments were passed to the UNION function. The minimum argument count for the function is 2."

Do you know whye?

Thank you,

Sam

[v-kelly-msft · Accepted solution]

Hi @Sam82 ，

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]

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