Vlookup

[Anonymous]

Hi everyone, im new to power bi. Ive been trying to achieve data using vlookup but i am unable to do so. My aim is to:

-Extract value of data on the firstday of the month at 12 am. (First of the month Table) and pair with each dates on (Main Table)

Error ive gotten : A table of multiple values was supplied where a single value was expected.

Hopefully someone could help, Thank you.

[Anonymous]

May i know how i could send you my data, Thank you

[bcdobbs]

Best way is to share a link from one drive/Google drive/drop box etc.

[bcdobbs]

Hi,

You're getting the error because for a particular date key LOOKUPVALUE is finding more than one energy data values.

Are you able to share a demo file with your structure and some sample data or just some tables of dummy data for each relevant table. Normally there are better ways to achieve what you are trying  by leveraging existing relations (RELATED and RELATEDTABLE).

[bcdobbs · Accepted solution]

Give this code a go:

Value 1day 12am = 
    LOOKUPVALUE(
        FirstoftheMonth[energydata_value], 
        FirstoftheMonth[DateKey],'Main Data'[DateKey], 
        FirstoftheMonth[devicename_id], 'Main Data'[devicename_id] 
    )

[Anonymous]

This definitely does its job! Thank you so much !!!