topic Re: LOOKUPVALUE (A table of multiple values was provided, a single value was expected.) in DAX Commands and Tips

LOOKUPVALUE (A table of multiple values was provided, a single value was expected.)

Thiagops — Thu, 05 Jan 2023 13:16:10 GMT

Hi, When trying to use the LOOKUPVALUE formula in POWER BI, the following error was returned: A table of several values was provided, and a single value was expected.

Faturamento = LOOKUPVALUE(NF_SAIDA[NS_DATA_EMISSAO],

NF_SAIDA[PV_CODIGO],

PEDIDO_VENDA[PV_CODIGO])

NF_SAIDA[NS_DATA_EMISSAO]: Column containing the date the order was invoiced

NF_SAIDA[PV_CODIGO]: Column containing the SKU of the product (Table only for orders that have already been invoiced)

PEDIDO_VENDA[PV_CODIGO]): Column containing the SKU of the product (General typing table: budget or order)

Re: LOOKUPVALUE (A table of multiple values was provided, a single value was expected.)

tamerj1 — Thu, 05 Jan 2023 13:34:56 GMT

Hi Thiagops
Is the [PV_CODIGO] unique in the NF_SAIDA table? Any relationship between the two tables?

Re: LOOKUPVALUE (A table of multiple values was provided, a single value was expected.)

Thiagops — Thu, 05 Jan 2023 16:17:27 GMT

Hi,

Thanks for the tip. I went to look and it really had duplicate values. I fixed it and it worked.

Thank you very much.

topic Re: LOOKUPVALUE (A table of multiple values ​​was provided, a single value was expected.) in DAX Commands and Tips

LOOKUPVALUE (A table of multiple values ​​was provided, a single value was expected.)

Re: LOOKUPVALUE (A table of multiple values ​​was provided, a single value was expected.)

Re: LOOKUPVALUE (A table of multiple values ​​was provided, a single value was expected.)

topic Re: LOOKUPVALUE (A table of multiple values was provided, a single value was expected.) in DAX Commands and Tips

LOOKUPVALUE (A table of multiple values was provided, a single value was expected.)

Re: LOOKUPVALUE (A table of multiple values was provided, a single value was expected.)

Re: LOOKUPVALUE (A table of multiple values was provided, a single value was expected.)