Forum Discussion
dom-mitchell
3 years agoFrequent Visitor
LOOKUPVALUE based on 2 variables issue
Hi all, I'm trying to get a value (Team) from one table (Team List) to pull through to a new column in a second table (Target List) based on two columns within both tables (Name and Month) which...
parry2k
3 years agoSuper User
dom-mitchell I just did with your sample data and it works, see attached Power BI file.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
dom-mitchell
3 years agoFrequent Visitor
Yeah, it looks to be the same as mine but for some reason, mine just doesn't pull the data through correctly.
Could I email you the PBIX? Don't really want to put it up here for download.