Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to Solution.
Hi, @rakeshmistry1
@rakeshmistry1
you can do using treats
Column 2 =
CALCULATE(
MIN('Table 1'[total]),
TREATAS(
VALUES('Table 1'[id]),
'Table 2'[id]
)
)
Hi, @rakeshmistry1
@rakeshmistry1
you can do using treats
Column 2 =
CALCULATE(
MIN('Table 1'[total]),
TREATAS(
VALUES('Table 1'[id]),
'Table 2'[id]
)
)
Thank you very much... it worked for me perfectly.
In Table1 create a calculated column:
DocTotal := LOOKUPVALUE(Table2[DocTotal], Table2[DocEntry], Table1[DocEntry])
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
21 | |
17 | |
14 | |
10 |
User | Count |
---|---|
42 | |
35 | |
25 | |
23 | |
23 |