lookup value (Help me)

[JavidRob]

Hi guys
I have two tables, in one of which I have a unique code and in the second table I have all the orders of that unique code on different dates. A DAX code with which I can create a column that shows the last customer date (FactorDate) in the first table from the second table. (Format date is a Text)Table 1 Unique CodeTable 2 Unique Code FactorDate

[FreemanZ · Accepted solution]

hi @JavidRob 

try to add a calculated column in Table1 like:

LastDate = 
MAXX(
    FILTER(
        Table2,
        Table2[Unique Code] =Table1[Unique Code]
    ),
    Table2[FactorDate]
)

[JavidRob]

Thank you so much 😍

[JavidRob]

Unfortunately, the "FactorDate" column in my table2 has a text format, not a date, so I think the function "LastDate" doesn't work

[FreemanZ]

hi @JavidRob 

then try like:

LastDate =
MAXX(
    FILTER(
        Table2,
        Table2[Unique Code] =Table1[Unique Code]
    ),
    DATEVALUE(Table2[FactorDate])
)

[JavidRob]