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

[@JHatLpool]

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

[@darrendenton9667]

Bro you saved my job - cheers

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

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

[@kuto1]

Very clear, and easy to understand. Thank you !

[@priyaagarwal4559]

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

[@thomashogan1985]

Straight forward solution, thank you!

[@edgarrodriguez712]

Your tips and tricks are very helpful! 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.

[@jawadahmadehssan6251]

Thanks Fernan, well explained.

[@jasonolson4581]

That was easy, thank you much.

[@davidpreston3214]

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

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

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

[@daonguyen521]

Thank you ❤❤

[@sapnalohana7459]

Amazing explantion

[@seenumohan3413]

Can we use lookup value function in a measure ?

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

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

[@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.