Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Vlookup

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 mon...
Need Help
Show and Tell
Tutorial Requests
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

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