Forum Discussion

Quenril's avatar
Quenril
Icon for Resolver I rankResolver I
2 years ago
Solved

Lookup column of data from another table with time variable

Hello,   I hope someone can help. I have a 'Client meeting' table in which I am trying to populate the 'Consultant Practice' and 'Consultant Team' columns from my 'Consultant lookup' table via calc...
Need Help
  • Quenril's avatar
    Quenril
    2 years ago

    Hello,

    Thankyou both so much. I have tried both versions and they return exactly the same result as I had before... Do you have any other ideas? The Client table I provided has the Consultants listed as Attendee 1/2 etc, however I've unpivoted that part in Query Editor so when I look at the table in Power BI itself I have a column for 'Lead of Invitee' and then a column called 'Consultant Name' which is the column I want the lookup to use...

     

    Do you have any other ideas please?

    Thank you

    Becky  

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

I don't like this part:

CALCULATE(
        VALUES

That's going to return a table.

It's possible (though I have never tried it) that you get data being returned if there is only one row being returned from this but not multiple rows or blanks or nulls. Just a theory but you can investigate at your side.