DAX Fridays! #84: FIFA WC 🏆 (Part 4) - Get values from another table with inactive relationships

It is world's cup fever: FIFA world cup 2018 in Russia!!! And we dont want to miss anything right? That is where Power BI comes to the rescue :) I am going to build a Power BI file to follow the world cup and I decided to show you how I create it while creating it :) In the first video, I downloaded in Power Bi the world cup data from FIFA world cup 2018 website and cleaned it to know when the matches occur, the groups and the flags. https://www.youtube.com/watch?v=i24MdCAjL68 In the second part, we built the first tab on matches: https://www.youtube.com/watch?v=6dwuwPMRXek 1. When is my favourite group playing? 2. When is my country playing? 3. Which matches will be sent today and at what time? In the third part, I will show you how to adjust the match times for your local time and some other improvements. https://www.youtube.com/watch?v=tKsbXRE6mIE And it today's video, we will try to pass the flag urls using inactive relationships, the USERRELATIONSHIP function and the LOOKUPVALUES function. As a reference for this video check out: Javier's blog post: https://javierguillen.wordpress.com/2013/09/18/dax-context-propagation-inactive-relationships-and-calculated-columns/ https://javierguillen.wordpress.com/2013/09/18/dax-context-propagation-inactive-relationships-and-calculated-columns/ DAX Fridays: USERRELATIONSHIP: "https://www.youtube.com/watch?v=sONvctPlplY&vl=en" LOOKUPVALUE: "https://www.youtube.com/watch?v=iJfzfYt5Qws" And Marco Russos: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/ And in Part 5 video, I will show you how to download and visualize the knockout phases in Power BI. https://www.youtube.com/watch?v=zxtmT64EmiU You can download the Power BI file here: https://curbal.com/blog/follow-the-fifa-world-cup-2018-in-power-bi Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU Link to DAX Fridays survey: http://bit.ly/2MMM4KK Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ************ ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP #WORLDCUP2018