Forum Discussion
Unique values from two columns
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,
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)] ) ) )
3 Replies
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.
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 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)] ) ) )
