Forum Discussion

JavidRob's avatar
JavidRob
Regular Visitor
3 years ago
Solved

lookup value (Help me)

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...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi JavidRob 

    try to add a calculated column in Table1 like:

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

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi JavidRob 

try to add a calculated column in Table1 like:

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

 

JavidRob's avatar
JavidRob
Regular Visitor
3 years ago

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

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi JavidRob 

    then try like:

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