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

  • ParthaD's avatar
    ParthaD
    New Member
    3 years ago

    Thank you for supporting us with your experiance and knowledge, today(16-12-2022), i was also stuggling to get the resultant week no, but, post reading you blog, i am able to fix this for my organisation. Thank you again Xiaoxin Sheng.