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.
   • FIFA World Cup 🏆 2018 (Part 1) in Power BI...  

In the second part, we built the first tab on matches:
   • FIFA World Cup 🏆 2018 (Part 2) in Power BI...  
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.
   • FIFA World Cup 🏆 2018 (Part 3) in Power BI...  


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/2...
https://javierguillen.wordpress.com/2...

DAX Fridays: USERRELATIONSHIP: "   • DAX Fridays! #21: USERELATIONSHIP  "
LOOKUPVALUE: "   • DAX Fridays! #41: LOOKUPVALUE with multipl...  "

And Marco Russos: https://www.sqlbi.com/articles/userel...

And in Part 5 video, I will show you how to download and visualize the knockout phases in Power BI.
   • FIFA World Cup 🏆 2018  (Part 5) in Power B...  

You can download the Power BI file here:
https://curbal.com/blog/follow-the-fi...

Get Northwind Dataset:    • Northwind data source: A great online sour...  

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

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