LOOKUP VALUE error message

[azizdoghmi]

Hi, 

I need to make a lookup value between 2 tables but I have the message : "One of the columns must have unique values"

Here a my tables : 

Table 1

ID project             Update date

1                            30/03/19

1                            25/03/19

2                            12/01/19

..

Table 2

ID project              Name project

1                             A

2                             B

I need to have for each project, the last update (so the most recent date).

thnak you for your help

[v-frfei-msft · Accepted solution]

Hi @azizdoghmi ,

To create a calculated column as below.

Column = CALCULATE(MAX('Table'[Update date]),FILTER('Table','Table'[ID project]='Table (2)'[ID project ]))

[Anonymous]

Could you just merge the queries on the ID Project?