Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, we have an issue with our data table. We would like to search a data in a different table (like VLOOKUP in excel) in our Power BI desktop. How we could do it?
Thank you in advance.
Solved! Go to Solution.
You could use LOOKUPVALUE:
https://msdn.microsoft.com/en-us/library/gg492170.aspx
You could use LOOKUPVALUE:
https://msdn.microsoft.com/en-us/library/gg492170.aspx
It's easy to do but without knowing what your two tables are, how they're related and what end result you want it's hard to suggest the best way to go about it
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |