Forum Discussion
Combining 2 tables based on unique values
I have a question and I need to combine 2 datasheets (2 different tables) based on unique values is both columns. Both tables have the column with the unique value SearchCode and however 95% of the ...
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])
