Forum Discussion

fmarthidalgo's avatar
fmarthidalgo
Frequent Visitor
3 years ago
Solved

New Column With LOOKUPVALUE DAX

Good morning all!    I'm having trouble trying to create a new column based on the criteria of the two prior columns.    I have column A and Column B. I need to find a way to create column C (Typ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  fmarthidalgo ,

     

    Whether the connection mode of your data source is Direct Query connection mode, the Earliest() function is not supported on Direct Query connection mode

    You might consider using the following DAX:

    VAR keyword (DAX) - DAX | Microsoft Learn

    Column =
var _number=[INVNUMB]
return
MAXX(
    FILTER(ALL('Table'),
    'Table'[INVNUMB]=_number),[Type])

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  fmarthidalgo ,

 

Whether the connection mode of your data source is Direct Query connection mode, the Earliest() function is not supported on Direct Query connection mode

You might consider using the following DAX:

VAR keyword (DAX) - DAX | Microsoft Learn

Column =
var _number=[INVNUMB]
return
MAXX(
    FILTER(ALL('Table'),
    'Table'[INVNUMB]=_number),[Type])

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly