Problem with weeks

[Anonymous]

Hello, I have tried to get "week" to slicer but I have faced problems with it.

This was the best attempt so far. But it gives that 1.1. (January 1st) is week 1, 2.1. (January 2nd) is week 2 et cetera.

There (https://insightsoftware.com/blog/working-with-weeks-in-power-bi/)
is a good guidance how to do it, but I think the problem is my clock times.

(My Time-table:
1.1.2022 0.00.00
1.1.2022 1.00.00
1.1.2022 2.00.00
etc.)

Can anyone help me? And feel free to ask further questions if needed 🙂

[Thejeswar · Accepted solution]

@Anonymous ,

To get the Week information, date information is sufficient. I don't think the presence of time might have any impact on this

But per my understanding, the system locale might impact the way the week numbering is done.

By default, Week numbering is done from Sunday to Saturday. i.e. As per Power BI, a week starts on a Sunday and ends on a Saturday

So In your case, since 1st January is Week 1 and 2nd January is Week 2, that is how it is working.

If you want to change the way this numbering of week is done, you should try using the other optional parameter in WEEKNUM() DAX function. An example is shown below

WeekNo_startsSunday = WEEKNUM('Date'[Date]) --> Week is from Sunday to Saturday

WeekNo_startsMonday = WEEKNUM('Date'[Date], 2) --> Week is from Monday to Sunday

WeekNo_startsTuesday = WEEKNUM('Date'[Date], 12) --> Here the week is from Tuesday to Monday

There are many other options you have, which you can try for the [ReturnType] as per your requirement as shown below

Regards,

[Anonymous]

Hi Thejeswar!

And thank you for your response!

WeekNo_startsMonday = WEEKNUM('Date'[Date], 2) --> Week is from Monday to Sunday
I tried this before, but didn't understand it correctly, I thought it is oding something wrong because there were just like I said 1.1. and 2.1. week one - I didn't realize that it is just like it must to be 😄 

And the other thing: There were something wrong with my visualization so it was the second thing I think there is something wrong with it. But I copied other visualization to there and edited it a bit so I think now it's working! I'll be in touch if I see it doesn't 😛

Thank you!