Forum Discussion
Lookup help
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)
Hi, thanks for taking a look.
In answer to yuor questions:
1. I get the following error message with both the LookupValue and the suggestion below: "A single value for column 'Datename' in table 'Import' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as a min, max, count, or sum to get a single result."
2. Fair point, I just knocked it together to scramble the real data.
I can't get as far as seeing any results, even if they were all £1 because of the error message.