How to use LOOKUPVALUE to match data between two tables // Beginners Guide to Power BI in 2021

[@darrendenton9667]

Bro you saved my job - cheers

[@JHatLpool]

A nice, clear demonstration of the point. You now have our permission to take the dog for a walk.

[@kuto1]

Very clear, and easy to understand. Thank you !

[@luc_Bft]

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.

[@mjescrihuela]

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!

[@FhargaZ]

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!"

[@thomashogan1985]

Straight forward solution, thank you!

[@priyaagarwal4559]

Recently came across your channel, well explained every topic ✌️🙃

[@edgarrodriguez712]

Your tips and tricks are very helpful! Thank you!

[@jasonolson4581]

That was easy, thank you much.

[@jawadahmadehssan6251]

Thanks Fernan, well explained.

[@davidpreston3214]

Fernan, Can you explain how to alter DAX to return both Beverages and Confections???? Thanks, Dave

[@tinaflemons263]

Can you use new lookup value to create a relationship to another table?

[@SolutionsAbroad]

Hi, do you mean creating a new lookup column then creating a relationship with another table? If so, then of course you can!

[@RS-to6sp]

Hi fernan, i have much question about dax PBI. can i asking more maybe in whatsapp or others chat communication ?thank

[@vanishedxu]

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.

[@SolutionsAbroad]

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

[@vanishedxu]

@@SolutionsAbroad Nice! I wish I could know which functions to look for when I have a problem to solve.

[@SolutionsAbroad]

@@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!

[@paulinevaret7277]

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?

[@seenumohan3413]

Can we use lookup value function in a measure ?

[@sapnalohana7459]

Amazing explantion

[@ankitaarya6600]

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??

[@daonguyen521]

Thank you ❤❤

[@TheJaebeomPark]

thanks

[@elinavinni6540]

Isn't there a puppy on the sofa? 😃🐶

[@SolutionsAbroad]

Haha, well spotted!

[@arunv1909]

tell your pup , I said a HI

[@grahamtheobald9726]

You use three values with very similar descriptions.....very hard to follow.