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] 
    )
bcdobbs's avatar
bcdobbs
Community Champion
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

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