# FOOTBALL PROJECT #7: Calender +ohter pages - La Liga Power BI ## Метаданные - **Канал:** Curbal - **YouTube:** https://www.youtube.com/watch?v=A0NqmmBz1Ok - **Дата:** 27.02.2026 - **Длительность:** 13:16 - **Просмотры:** 533 ## Описание While building the standings and matches pages, I realized that we are missing the calendar table, so I build that here too. You can get a version of that here: https://codeberg.org/Curbal/PBI-Functions-and-Scripts/src/branch/master/Calendar.pq Join this channel membership to get access to all the recorded bites as they become available: https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw/join Here you can download all the pbix files: 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 ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Mastodon ► @ruthpozuelo@techhub.social Twitter ► @curbalen Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE ## Содержание ### [0:00](https://www.youtube.com/watch?v=A0NqmmBz1Ok) Segment 1 (00:00 - 05:00) Okay. So, what we're going to do today is not one but two pages. We're going to do the remaining because it's not that difficult. So, we will do the page where we see the standings to see you know the actual final classification for now and then we will see we will create the um matches so we can see when they're playing in case we want to follow them. So, new page standings And we have our standings table. Remember that we have now the new slicer table. And we need to get the theme from there if we want our homepage to work. So this global filter to apply everywhere. So we need to get the teams from there. But then we're going to get the played. So this is how many matches they played, how many they've won, how many they lost, how many they have, you know, like a tie. And then we have, you know, we can put the goals deep if we want to, and then we can put the number of points. So we see how far away they are from each other and filter by that thing the other way around. And we can see my lovely ovo down there. Okay, so they've played 22, they won three matches and they lost 12 seven draw, right? Okay. Poor things. um the actual formatting we will take care about on I guess the final video where we do the formatting and the pitch navigation all that stuff. So next one is the matches and for the matches we want this is for us to be able to go and say okay who's playing today or when is my team playing if I use a global filter. So for the matches we want to have the team a logo needs to be an image URL. Same with the team home logo. So we're going to put the home team first the logo. Then I'm going to put the matching needs to come from the slicers otherwise your global folder will not work. Then I'm going to put the team a logo. And then I am going to put the date, the time, the time, the time, at what time they play. If you want, you can actually put the date. Actually made my time time. And that's what I did not want. Let's go back and change it. Time. I wanted to read text. I explicitly said that I don't want time. Well, I did not but you know when you are doing the texting types it is what it is. So date time right. So now I want to have a calendar here so we can actually see who is playing you know the when it's Saturday when it's Sunday and all that stuff. So we need to go to shop uh and get some custom visual because far does not have a calendar by default. You can always do stuff but you know this is a just for fun that's not complicated calendar and the calendar that I used calendar it was this one two reasons it is certified make sure that your um custom visuals are always certified another one is simple right so obviously I don't want to have any free trial or any stuff but depending on what you want to do. If what you want added the custom visual is very simple pick simple one otherwise you know it takes time to learn how visual works it does. So click on there and then it wants a date. Oh our calendar I have not created a calendar. We need a calendar folks. So let's do that. So I have um in here on let me go back on code by I've moved all my stuff from gith to code by this opensource um github repository I have my parkquery stuff here my powerbi and I have a calendar so you can actually come here and borrow this um it will generate a calendar I'm going to use something similar this is so you can see actually where I I'm working ### [5:00](https://www.youtube.com/watch?v=A0NqmmBz1Ok&t=300s) Segment 2 (05:00 - 10:00) with, but it's not going to be exactly the same. So, we're going to transform data and then new source blank query and then you copy the code. This is European with ISO dates and things like that. So, it's very difficult to create a calendar that works for everyone. You know, the code would be like gigantic. So, that's why I'm going to share that. you know the basics of a calendar and then you can just transform it as you like. Um right so this is our calendar and here are a few things. So it I've hardcoded on the one that I keep for myself. I hardcoded the dates and then I changed those dates. So now it says from 2021 starting 2021 count the days until now and then the duration. We don't really want this because we have here on the matches when the LIA starts and when it ends. So when it starts is the mean date, when it ends is the max date. Because you might want to be able to follow different leagues using this. It is actually quite cool to not hardcode the dates. Instead of get them from the matches table. So what we're going to do, we're going to go to the calendar advance editor and here I'm going to get max date and it's going to be leaks list max matches. Was it called dates? I don't remember. Let me check. So done matches. Yeah. So if I go here to max state. Oh, all that Python writing gets to my head. So this is when La Liga will finish. We want one when La Liga started. So, it's basically going to be the same as these, but probably it's faster, too. Mean, date list mean matches and then date and another like that. Right. So, now we have one Liga finished. We have one La Liga start. So we're going to modify this a little bit so we actually get the dates depending on which league we are working on rather than hardcode. No. So this is the start date. So this is main date duration days. This is very weird. So power query wants to have the start date and then the number of days rather than a start and end date whatever you will get power query. So this is again the mean date and then here we have the max date max date. So we're going to we're basically saying well max date is a date so I don't need to have that. We're basically saying get the max date minus the mean dates and then calculate the duration between those and then add one. And then we want the our calendar or our at least to be day by day. That's what this duration says. So create one day by day. And this will actually create a calendar for us. Um if we go at the bottom with everything that we need, date, the day name, week name, year, month, you name it. Close and apply. Right. So we have our calendar there. And the calendar will have to go together with matches. So we have date and date, date and date. And then I'm going to do these. I don't know. Why is always so verbose? So annoying. Date. We're going to get it like that. I'm going to make date my date table. We're not going to do any time intelligence, but it's just, you know, it's a habit that is good to have so you don't forget doing it basically. Right. So now we have our date there and the metric is like what is going to ### [10:00](https://www.youtube.com/watch?v=A0NqmmBz1Ok&t=600s) Segment 3 (10:00 - 13:00) show on the calendar. We want to know when there is a match. So if we put match and instead of first we put count we see them there, right? So now we could go to February and then we see who is playing the 14th of February or the 13th of February or whatever. Right? So remember if you want to know when your team is playing is better to have it um fixed with the global slicer. We haven't actually fixed a global slicer yet. Maybe it's a good time to do it. So, we should go to sync slicers and then once it's there, you click on it. This is so weird. And then we don't want to see it, but we want to be able to sync it like don't show it. I always do this the last thing of everything because sometimes it's this breaks and when it breaks it can take like hours to realize that the reason that you are having problems with your tables is because this broke. So I do the very last thing just as a warning. So now that we have ODO, you see ODO and now we see one O is playing. Only I'm not sure if I put Yeah, lovely. So if instead of put the matches from matches, we put it from the slicer, then we will see also in the calendar when we are displaying. Why are they never playing? Or is this like This is like a Sunday stuff. Oh my god. Who has the Sunday at the beginning? I guess we can format that, right? Start date. Oh, yeah. Yeah. Thank God. There you go. So lovely. Here we go. Isn't this great? Right. So, for the next video, what we're going to do is the final touches like the, you know, adding the background, formatting the tables, putting the page navigation, all that stuff. Again, I will not do it now. So, because I want to hear if you want me to show you how to use Figma for the backgrounds. If you don't, I'll just, you know, I can share the images to you so you have them and then we just reuse them basically. And we will do also on the last one the mobile layout. So you can have it on your mobile. You can follow La Liga on your mobile. It's so cool. We will publish it to PowerBI and refresh and all that stuff. So we don't have a lot left, but I hope you're enjoying it anyway. Okay, I'm going to stop talking and I'll see you very soon. Bye. --- *Источник: https://ekstraktznaniy.ru/video/52927*