Forum Discussion
copying one column values to another based on two maching key values
Hey PBi Users, Need a quick help with something. So i have two tables in my project and I need to copy the value of two columns from one table to another table based on two keys. and ...
Without seeing the data I can't tell you what the problem is. My formula works against your expample data.
Changed = LOOKUPVALUE( Table2[Changed], Table2[ARD Key],Table1[ARD Key], Table2[Material Key],Table1[Material Key] )I have attached my sample file based on your example data. Take a look at that and see if it helps.
Unfortunately I cannot. It is work related confidential stuff :(
jdbuchanan71
Super User
Super UserWithout seeing the data I can't tell you what the problem is. My formula works against your expample data.
Changed =
LOOKUPVALUE(
Table2[Changed],
Table2[ARD Key],Table1[ARD Key],
Table2[Material Key],Table1[Material Key]
)
I have attached my sample file based on your example data. Take a look at that and see if it helps.
Got mine to work too.
Needed to tweak the formula a bit as there was another key which had a relationship with table 2.
Thanks for the help :)
PBi Community is great :)