Forum Discussion

ErickM49315's avatar
ErickM49315
New Member
3 years ago
Solved

Troubles using LOOKUPVALUE

Hi team, im trying to use VLOOKVALUE into Cycle account dashboard to return 1 or 0, it depends of 2 conditions: - 1 count pivot table's dates has the same dates as inventory - 1 count pivot table's...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  ErickM49315 ,

     

    The error message is because the second parameter of the SELECTCOLUMNS function should be the column name, but you are passing the table as a parameter.

    You can try the following dax:

    LOOKUPVALUE(
    'Inventario'[Cantidad], 'Inventario'[Date],'Tabla_Dinamica_Conteo1'[Date],'Inventario'[ID],'Tabla_Dinamica_Conteo1'[ID],1)

    Refer to:

    LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

     

    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  ErickM49315 ,

 

The error message is because the second parameter of the SELECTCOLUMNS function should be the column name, but you are passing the table as a parameter.

You can try the following dax:

LOOKUPVALUE(
    'Inventario'[Cantidad], 'Inventario'[Date],'Tabla_Dinamica_Conteo1'[Date],'Inventario'[ID],'Tabla_Dinamica_Conteo1'[ID],1)

Refer to:

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

 

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.