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

chbraun's avatar
chbraun
Helper I
9 years ago

Hi Paolo,

 

I am late to the conversation and I might be missing something here, but I don't quite understand why you are looking into LOOKUPVALUE for creating a chart showing enquiries by week. Wouldn't this approach work:

 

+ create measure to count enquiries, something like enquiries = DISTINCTCOUNT(EnquiryID)

+ make sure that the Enquiries table and the date table have a relationship

+ create a chart (for example bar chart) with week number as x-axis and enquiries metric as y-axis

 

Et volia - number of enquiries per week. :-)

 

Am I missing something here or is this what you are after?

 

Cheers,

 

Christian

 

Paolo750f's avatar
Paolo750f
Frequent Visitor
9 years ago

Hi Christian,

Your suggestion was how i expected things to work but when i try this i don't get the expected result.  below are a couple of screen shots to show what happens.

When i add 'week' to x axis this is what i get: