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 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'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]
)

     

5 Replies

  • 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])
)