Forum Discussion
Post PatronCombining 2 tables based on unique values
Post PatronThat did the trick but the new table has duplicate rows so how do I just get the unique values ?
Edit: the SearchCode is in both tables the same but some columns have a different value in table B then it has in table A and viceversa. Is it possible for the EXCEPT to just check based on the SearchCode ?
Resident Rockstarhi, RonaldvdH
yes, it possible just compare it with search code like below
new table=
var table_1 = SUMMARIZE(Table1,Table1[search code])
var table_2 = SUMMARIZE(Table2,Table2[search code])
var result = EXCEPT(table_2,table_1)
return
UNION(table_1,result)
it give only join of search column
if you still not get your answer then provide some sample data and expected output
- RonaldvdH
Dangar332 maybe I need a differnt approach ....
I can summarize both tables based on your formula but then I only have 1 column with SearchCodes (Unique values from both Table A and B)
But then I only have that column but I need the other columns as wel.
However this formula just checks values in table A but what I need is a formula that first searches table A and if that returns a blank then checks table B.
Can I change the varStreet formula so that it doesn just that ?
Straatnaam = VAR varSearchCode = Test[Searchcode] VAR varStreet = FILTER(ALL('Adressen'),Adressen[Searchcode] = varSearchCode) RETURN MAXX(varStreet,Adressen[straat])