Forum Discussion
Solved
Lookup help
Hi, I have two tables as per below. What I'm trying to do is assign a new column in the 'Import' table that looks up the DateName in that table, looks up the corresponding DateName in the 'Rate S...
ChrisPeall , seem file a new column in invoice
or try like
a new column = MAXX(filter('Rate Sheet', 'Rate Sheet'[DateName] ='Import'[DateName]),'Rate Sheet'[Rate])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Are you creating a measure or a calculated column? I thought you wanted a calculated column
2 points:
What's not working with the LOOKUPVALUE dax provided?
Also, the test sample doesn't look great because 1) the LOOKUP works 2) answers are all £1 (so not much of a test)