Troubles using LOOKUPVALUE

ErickM49315 — Tue, 25 Jul 2023 20:55:11 GMT

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?

Re: Troubles using LOOKUPVALUE

Anonymous — Thu, 27 Jul 2023 02:10:25 GMT

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.

topic Troubles using LOOKUPVALUE in DAX Commands and Tips

Troubles using LOOKUPVALUE

Re: Troubles using LOOKUPVALUE