Troubles using LOOKUPVALUE

[ErickM49315]

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 IDs has the same IDs as inventory

to this column im trying to calculate it as:

Qty_SU = LOOKUPVALUE('Inventario'[Cantidad], SELECTCOLUMNS(Inventario,Inventario[Date]=Tabla_Dinamica_Conteo1[Date]),"LPN",Inventario[ID],Tabla_Dinamica_Conteo1[ID],0)

Function SELECTCOLUMNS expects a column name as argument number 2.

It is pretended to select more than 1 day to see the results throw the time. as result obviously i got #ERROR

an advice to me?

[Anonymous · Accepted solution]

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.