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 ...
In the second part, we built the first tab on matches:
• FIFA World Cup 🏆 2018 ...
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 ...
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: javierguillen....
javierguillen....
DAX Fridays: USERRELATIONSHIP: " • DAX Fridays! #21: USER... "
LOOKUPVALUE: " • DAX Fridays! #41: LOOK... "
And Marco Russos: www.sqlbi.com/...
And in Part 5 video, I will show you how to download and visualize the knockout phases in Power BI.
• FIFA World Cup 🏆 2018 ...
You can download the Power BI file here:
curbal.com/blo...
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Looking for a download file? Go to our Download Center: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP #WORLDCUP2018