I cannot figure this one out. I am sure it is me not knowing VLOOKUP Alternative.

[Anonymous]

I have one data set that shows all the documents posted to a SharePoint site. I have another table that shows which accounts have goals tracked. There are incidents were documents could have been posted, however, goals aren't tracked. I only need the accounts where goals are tracked.

I have them related by Account Number.

However, I am not sure how to display this data.

I have all the information coming in from the CMV Adoption table, but I cannot figure out how to write the measure. I am so used to VLOOKUP that this is throwing me off.

[Greg_Deckler · Accepted solution]

There is now an equivalent function in DAX called LOOKUPVALUE.

Before that existed I wrote an entire article on this topic, which now seems dated and quaint... 😞

https://community.powerbi.com/t5/Community-Blog/Good-Ol-VLOOKUP-The-Ultimate-Guide-to-Lookups-in-Pow...

[Anonymous]

I saw your previous article. I just wanted to see if there was something else because it wasn't working for me.

Thank you so much 🙂

[Greg_Deckler]

Always happy to help! I should probably amend that article!