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

  • 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])
)
  • JavidRob's avatar
    JavidRob
    Regular Visitor
    3 years ago

    Thank you so much 😍