DAX Fridays! #84: FIFA WC 🏆 (Part 4) - Get values from another table with inactive relationships
HTML-код
- Опубликовано: 7 июн 2018
- 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.wordpress.com/2...
javierguillen.wordpress.com/2...
DAX Fridays: USERRELATIONSHIP: " • DAX Fridays! #21: USER... "
LOOKUPVALUE: " • DAX Fridays! #41: LOOK... "
And Marco Russos: 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 ...
You can download the Power BI file here:
curbal.com/blog/follow-the-fi...
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/donwload-center
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/contact
************
************
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
Love the calculated column approach. I tried the userelationship DAX way when the first Fifa world cup video came out but also couldn't get it to work. I thought I was doing it wrong but tuns out that it is a lot more difficult than expected. Great video and love the content. Makes learning fun. Thank you... Go Colombia in the world cup :)
That is great! What a fantastic way to learn combining different passions right?
/Ruth
Thank you
Great Ruth, quick and clear!
Thanks Baptiste!
/Ruth
Great videos Ruth, keep the good work! Fabuloso - Andres Martinez
Gracias!
Hi Ruth, Thanks a lot for this video ! I have an additional question: How do you deal with circular references when you try to use this same syntax on several columns of the same table ? Thank you in advance ! Charlotte
Hola Ruth. Como siempre, me encantan tus videos. Tienes razón. Dax suele confundir, sobre todo a los que no venimos de experiencias con excel, o vamos comenzando con Power BI. En estos días vi un video de The Guy in a cube, donde Patrick esta con Marco Russo hablando sobre escribir en Dax, y Marco muestra su pagina Daxformatter.com, que imagino habrás visto. Seria bueno que la mencionaras como herramienta. Los tips en ese video sobre escribir dax de verdad son muy útiles, no tanto para entender las funciones, pero si para leer y entender un script en Dax. Un abrazo Ruth. Feliz fin de semana.
Hola Rafael,
La he mencionado en varios vídeos, pero como yo no la uso, se me olvida usarla en los vídeos! Ouch!
Buen fin de semana :)
/Ruth
finished watching
Hi Ruth ! I'm rookie in PBI and DAX seems very hard to understand. I will need to watch this video a hundred times !!! kkkk
It takes a bit of practice to learn it, but you will get there, don’t give up!
/Ruth
Great videos!. Quick Question: Do you know if it is possible to create a calculated table using SelectedValue from the visualization part as filter? Lo he intentado sin éxito, gracias por tu tiempo!
Mmmmm no se muy bien a que te refieres, podrías poner la prengunta en la comunidad de power bi?
/Ruth
very useful
Thanks and happy Saturday:)
/Ruth
And in 2020 do you have the solution for 2 one to many relationships?
What if lookup value returns multiple values? Does this increase the number of rows in the table? I mean does it work like a left join?
Is this what you are looking for?
m.ruclips.net/video/e8OWQ7Xl3m0/видео.html
/Ruth
Better than Netflix, and I learned something again
😂😂 wow ! That is a compliment!
Happy Friday Sten!
By the way, did you received the gift?
/Ruth
yes and thank you. My boss has tried to snatch my new mouse mat from my desk a couple of times.
😂😂😂😂 He can have one too, just have him send me his address.
Happy Friday :))
/Ruth
No, I will try to get him to subscribe to your channel, so he can participate in your next challenge.
You are right, make him work for it 😂😂
Have a great weekend!
/Eugh