Forum Discussion
joshua1990
Post Prodigy
6 years agoVLOOKUP with MAX
Hello everyone! I have two tables: tblOrder Order Date Value 1001 01.01.2020 500 1002 01.01.2020 tblWork Order SEQ State String 1001 50 1 AAA 1001 50 2 ...
joshua1990
Post Prodigy
6 years agoThanks for your approach! Unfortunately, I get the following error:
Calculation error in measure YXX : A single value for column 'XX' cannot be determined in table 'XX'. This can happen when a measure formula references a column that contains many values without specifying an aggregation such as 'min', 'max', 'count' or 'sum' to get a single result.
Anonymous
6 years agoNot applicable
This is not a measure. It's a calculated column. This is what you asked for.
Best
D
Best
D