Forum Discussion
Quenril
Resolver I
Resolver ILookup 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...
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
Community Champion
Community ChampionThere's no 'Client Meetings'[Consultant Name] column in the data provided. It's in the calculated column - is it supposed to refer to
Consultant Attendee 1?
What rows show the problem you are experiencing and what are you expecting to see?