How to use LOOKUPVALUE to match data between two tables // Beginners Guide to Power BI in 2021
ฝัง
- เผยแพร่เมื่อ 26 มิ.ย. 2024
- Get Demo Files here
ko-fi.com/s/a0da6f11b9
In this video were going to cover how you can use the LOOKUPVALUE DAX function in Power BI to match data between two tables, along with my recommendation for an alternative.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of TH-cam.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence
A nice, clear demonstration of the point. You now have our permission to take the dog for a walk.
Thanks a lot! I've been trying to find a solution to filter data from a chart based on another table's data and this worked as expected!
Your tips and tricks are very helpful! Thank you!
Very clear, and easy to understand. Thank you !
Bro you saved my job - cheers
Straight forward solution, thank you!
Recently came across your channel, well explained every topic ✌️🙃
That was easy, thank you much.
Thanks Fernan, well explained.
Good video, i was checking how to compare two queries and tables about some data missing form one to another and other conditions, this i can use it later for the building of the report.
i was wondering if your dog was making fun of you on your back: "pffff (blah blah blah, human talking, blah blah) take me to the park!! I will have my revenge on that squirrel!"
Amazing explantion
thanks
Thank you ❤❤
Hi Fernan! I absolutely love all of your videos, thank you so much for producing them! Always well explained and very informational.
In this case I tried to reproduce both methods with a condition based on a date. I want to build a look up that only returns values after a certain date, but it seems like there is a formating issue. Which format should be the date in? It is actually not the first time I have this kind of issue with dates.
[Created Date] >"01.01.2020" is what I tried. There is no error mistake, but everything gets written as null in the column. Do you have any recommandation for IF commands when dates are needed?
I learn something new everytime. Your videos make too much sense from the first second to the last. Well done! Fernan.
Now I'm curious. Did you take some kind of DAX course to know all these functions? Or did you read through the entire DAX docs on Microsoft and try each of them out so you would know when to use what? I feel like I'd rather watching your videos than reading the docs.
Hi Van, thanks for your support and thanks for watching!
It helps that I work with Power BI quite a lot in my day job, so typically I have a problem I need to resolve, then I look for any DAX functions that can help.
I've not read the entire DAX docs though, I think that would be excessive lol
@@SolutionsAbroad Nice! I wish I could know which functions to look for when I have a problem to solve.
@@vanishedxu You dont need to! Most of the time other people have had the same problems, and I see what functions they use, that's how I typically discover new functions.
It gets easier overtime, just have to spend more time with it. Good luck!
hello, fernan. I'm looking for a function that can lookup a date in previous records in a list of events (timestamp/EventID/ON/OFF). I'd like finally to calculate duration of appearance for each events. A little bit complicated for me 😒. Could you tell or show me the trick. It could be interesting for people working on numerical machines. Thanks.
Can you use new lookup value to create a relationship to another table?
Hi, do you mean creating a new lookup column then creating a relationship with another table? If so, then of course you can!
Can we use lookup value function in a measure ?
Can i apply vlookup between more then two tables
First value map with 1 table
After that rest null values map with 2 table
Abd then map with 3rd table
Is this possible??
Isn't there a puppy on the sofa? 😃🐶
Haha, well spotted!
tell your pup , I said a HI
You use three values with very similar descriptions.....very hard to follow.