Unique values from two columns

[pbrekelmans]

Hello all,

I'm still fairly new to this piece of software, but greatly impressed by the possibilities it has given, especially because i have a lack of real knowlegde on this matter. This forum has helped me countless times, but not on this (easy?) problem i'm having lately.

Situation:

I have a couple of datasheets. All of them share one unique value: the number of an  "object". This object can be related to our workers (table 1), or to other activities (table 2). I would like to make a graph showing for each object who handled it (table 1) and what activities where taken (table 2).

Problem:

I want to make one column with unique values (object-numbers) from those two tables. I just cant figure it out. Any help would very much be appreciated.

With kind regard,

[erikajain02]

I am not sure if I understood your problem completely , but you can try to create Index column accordingly.

If you can upload some sample data and the output required. This will help us in understanding the exact requirement.

[pbrekelmans]

I don't think the index column will help me now. But i can show you some purely fictional tables that represent the "problem" (see below). I cannot connect table 1 and 2 because they have more than 1 value for some lines. I think i need to make a new list with unique values (table/list 3) to tackle this.  

Table 1
date	dinner	consumed by (object number)
1-1-2018	Salisbury Steaks	3223
1-3-2018	Beef Stroganoff	2551
1-4-2018	Tacos	3223
1-5-2018	taco salad	1221
1-7-2018	chicken fajaitas	2551
Table 2
date	client with problem (object number)	problem
21-feb	4562	headache
3-feb	1221	opstipation
5-aug	2551	blurry view
1-mrt	2551	frozen shoulder
1-jun	3223	weak knees
Table 3 (to be)
Object number
3223
2551
1221
4562

[v-chuncz-msft · Accepted solution]

@pbrekelmans,

You may add a calculated table as follows.

Table =
DISTINCT (
    UNION (
        SELECTCOLUMNS ( Table1, "object number", Table1[consumed by (object number)] ),
        VALUES ( Table2[client with problem (object number)] )
    )
)