topic Re: HOW TO BRING VALUE FROM ONE TABLE TO ANOTHER TABLE IN NEW COLUMN WITHOUT TABLE RELATIONSHIP IN DAX in DAX Commands and Tips

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

rakeshmistry1 — Fri, 29 Dec 2023 09:22:20 GMT

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?

lukiz84 — Fri, 29 Dec 2023 09:32:47 GMT

In Table1 create a calculated column:

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

Dangar332 — Fri, 29 Dec 2023 09:47:54 GMT

Hi, rakeshmistry1
rakeshmistry1
you can do using treats

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

rakeshmistry1 — Fri, 29 Dec 2023 12:10:44 GMT

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