Forum Discussion

Paolo750f's avatar
Paolo750f
Frequent Visitor
9 years ago
Solved

LOOKUPVALUE returns blank value

Hi, I'm pretty new to Power BI but have suddenly become my companies 'expert' ;-) I'm being asked to produce a chart to show 'Enquiries' by week. This could be week YTD or Fiscal week.  Following a...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Paolo750f,

     

    I modified your formula and it seems work on my side with your sample data, you can try to use below formula if it suitable for your requirement:

     

    Week = LOOKUPVALUE(DateKey[Week],DateKey[Date],DATEVALUE(leads[new_enquirydate]))

     

     

    Regards,

    Xiaoxin Sheng

Anth79's avatar
Anth79
Advocate I
6 years ago

I'm getting an error with something similar, I know its probably me just missing something simple:

 
Opportunity FY = isblank(if( LOOKUPVALUE('FWS Receipts Household'[Opportunity Start Date], 'FWS Receipts Household'[Supporter URN], 'FWS Receipts Supporters'[Owning Party URN]), 'FWS Receipts Supporters'[Opportunity Start Date], LOOKUPVALUE('FWS Receipts Household'[Opportunity Start Date], 'FWS Receipts Household'[Supporter URN], 'FWS Receipts Supporters'[Owning Party URN])))
 
I'm trying to pull through the start date realting to the Household a Supporter belongs to, when the Supporter has a blank start date, but get the following
ERROR: A table of multiple values was supplied where a single value was expected.