HOW TO BRING VALUE FROM ONE TABLE TO ANOTHER TABLE IN NEW COLUMN WITHOUT TABLE RELATIONSHIP IN DAX

[rakeshmistry1]

Hi I have two tables..

TABLE 1 (DocNo, DocEntry, DocTotal, Date, Misc...)

TABLE 2 (DocNo, DocEntry, DocTotal, Date)

I want to pull Doc Total of TABLE 2 into TABLE 1 for Matching DocEntry field.

But there is not relationship between two tables.

So how to do that with DAX?

[Dangar332 · Accepted solution]

Hi, @rakeshmistry1 
@rakeshmistry1 
you can do using treats

Column 2 = 
CALCULATE(
   MIN('Table 1'[total]),
   TREATAS(
     VALUES('Table 1'[id]),
    'Table 2'[id]
   )
)

[rakeshmistry1]

Thank you very much... it worked for me perfectly.

[lukiz84]

In Table1 create a calculated column:

DocTotal := LOOKUPVALUE(Table2[DocTotal], Table2[DocEntry], Table1[DocEntry])