Forum Discussion
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 IDs has the same IDs as inventory
to this column im trying to calculate it as:
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?
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.
1 Reply
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.