Forum Discussion
Find value based on two others
IN a table I have the following columns:
SHOP, DATE, VALUE. In another table I have the following column: STORE, DATE, VALUE2
I want to retrieve the VALUE2 of the second table based on the STORE and the DATE and unify it in the first table.
Hi, Anonymous
You can try function 'lookupvalue' to retrieve the VALUE2 of the second table.
calculated column:retrieve the VALUE2 = LOOKUPVALUE(Table2[VALUE2],Table2[DATE],Table1[DATE],Table2[SHOP],Table1[SHOP])Please check my sample file for more information.
Best Regards,
Community Support Team _ Eason
2 Replies
Hello @jspower a query what you need is to create a new table with the fields Store, Date and Value2, it is what you need, or you need the report of Table 1 that are the fields Store, Date and Value to add to the report the Value2 of Table2.
Waiting for your comments
Best regards
Hi, Anonymous
You can try function 'lookupvalue' to retrieve the VALUE2 of the second table.
calculated column:retrieve the VALUE2 = LOOKUPVALUE(Table2[VALUE2],Table2[DATE],Table1[DATE],Table2[SHOP],Table1[SHOP])Please check my sample file for more information.
Best Regards,
Community Support Team _ Eason
