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

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

Paolo750f's avatar
Paolo750f
Frequent Visitor
9 years ago

Hi Xiaoxin,

Your formula works great, thank you for your help :-)

Regards,


Paul