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

[Thiagops]

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)

[Thiagops · Accepted solution]

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.

[tamerj1]

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