Oh my...! You DIDN'T KNOW this about WEEKS?!

Understand how to analyze by week in Power BI
Analyzing by weeks can be more insightful than by months, however it can be quite trick. Let me give you the 2 main concepts you need to know when doing time intelligence on weeks.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:28 Why break down by weeks
01:14 Adding weeks to a date table
03:14 Adding ISO weeks (EU standard)
06:05 Adding ISO years
07:31 Week calculations
15:09 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[utkudulger]

3 hours ago I was looking just for this. Now it is there, you literally made my day. Thank you very much and keep up the good work👍👋🏻

[JustRandomExplorer]

Wow did not know the WEEKNUM iso formatting "21". Thanks! Keep it up. You are one of the few PBI youtubers that actually present valuable content. Keep it up!

[MrRobvanzutphen]

Hi Bas, great video as always! Weeks are a really pain the *ss. What people also should be careful about is that every 7 years the number of weeks in a year is different. When calculating the 'same week previous year' you' ll have to deal with this as well. Then another issue is that because of that, for example, Christmas doesn't always fall in the same weeknumber. So another complexity to deal with! Good to read from everyone's reactions I'm not the only one fiddling with weeks 😊

[dcpowered]

This is extremely useful!! I've been struggling for months to get a running previous week calculation! But could you PLEASE make a full video on the ultimate calendar table which includes the week number for several years, for example, from 2020 until 2025?

[garyknott]

Cool trick to create a week ID that continually rises, also from year to year!

[evelynlivant]

This video gave me the solution to a client requirement for reporting week over week calculations! They needed the previous year included, but did not want to show the year in the visual and the usual filters were filtering out the data. Thank you!

[alicedwonderland]

The 'Don't Summarize' option for certain columns is amazing! Until now, I kept using it in all the tables I inserted in the reports, over and over. Bas, you rule.

[mdtauhidalam]

Paused the video in the middle, to say you that you are a great instructor.
I was always stuck at these week based calculations, and was searching for some articles or videos that could help me understand it better. This is the video I was looking for.
Thank you so much, keep posting such great contents, wish you health and happiness. 😊

[DrumingSession]

Amazing - whenever I have a question pop into my head, you have a video to answer it. Great content as always!

[unnikrishnansanthosh]

i was searching for this and here you are, thank you BAS

[cindypayet]

Very, very USEFUL. A great big thank you !

[EYEmaginary]

I’ve been struggling so much with calculations per week. If possible always try to avoid. This helps a lot in understanding what is going on and not go crazy.

[punith]

Watching all your videos and trying in my system. Thank you😄 !!

[innocentigiwa]

Thanks for this. How do we take it further by showing Week 1 to Week 4 or Week 5 for each month. Every time we want to see Week 1 to Week 4 or Week 5 of each month. That way for example we're able to compare Week 3 of previous month with that of current month.

[TheTiM]

Great videos! Could you help me in solving the next problem? Instead of scrolling through a long table of data or using a filter selection pane of 52 weeks, I would like to use 2 buttons in the form of arrows in order to skip to next or previous week(s). Is this even possible in Power BI?

[tukaramjogdand]

Thank you Bas, Its really amazing. Thank you for sharing!

[MatusiSK]

Great Video!! It would be really great if you mentioned how to sort the ISO week in column or line chart so Week 52 appears at the beginning and not the end. Thanks.

[genevieve]

Hi Bas - good to know (tricky) - I have 3 small questions for you :
1) Instead of building continuous weeks, can we use OFFSET function to have the previous sales ?
(as this is on the previous line or will we have issue when go over a new year ?)
===> Happy New Year to you by the way 🎄
2) For Europe, maybe the video is missing the last info "(INT([Date]-Weekday([date], 3) - _StartWeek1)+7)/
--> what do we have to write after /
3) Why '3' in the formula for Europe ?
Thank you in advance - Geneviève

[laiqmehdi]

Superb superb superb god bless u always

[mehdihammadi]

Thank Bas for this great topic. Now, in addition to a repository for calendar elements and fiscal elements, there will be a repository for ISO Items