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
I have two tables - Table A and Table B. Table A contains SKU and Item Number. Table B contains SKU, Item Number and Weight.
I want to lookup the weight from Table B in Table A based on SKU column, if the same sku is not present in Table B then the lookup should be based on item number.
Here is the formula which I use in excel : IFNA(VLOOKUP(B3,$G$2:$I$5,3,0),VLOOKUP(C3,$H$2:$I$5,2,0))
Hello you need LOOKUPVALUE and use in this way
LOOKUPVALUE( <result_columnName>,
<search_columnName>,
<search_value>
[, <search2_columnName>, <search2_value>]…
[, <alternateResult>] )
https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
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 |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
106 | |
64 | |
60 |