Forum Discussion
vlookup from different dataset
Hello Team, I am taking my excel calculations to Power BI to automate and produce better visualization. I will have to do few VLOOKUPs between different sheets (different datasets here) and also ...
Anonymous,
Could you please share sample data of your tables and post expected result here? In Power BI, you can write DAX to look up value in different tables, you can take a look at the following similar thread to get more details.
http://community.powerbi.com/t5/Desktop/IF-VLOOKUP-ISNA-gt-DAX/m-p/229722#M102430
Regards,
Lydia
Ashish_Mathur
Super User
Super UserHi,
You should be able to performa your lookups in Power Query by joining Tables.
Hello Ashish,
Let me try that and let you know what happens.
Thanks a lot!