topic Week start day monday in DAX Commands and Tips

Week start day monday

Rahma — Tue, 03 Jan 2023 14:18:03 GMT

Hello guys,

I need to check if the day is a weekend or not, knowing that the week should starting with Monday.

And to do it, i used weekday function.

But the result is not correct. I have tried all the options and these are the diffrent results i have:

weekday([date], 1) ===> Friday 1, saturday 2 , sunday 3

weekday([date], 2) ===> saturday 1, sunday 2, monday 3

weekday([date], 3) ===> saturday 0, sunday 1, monday 2

and what i need is that the number of monday should be 1 , saturday 6 and suday 7 as described in the documentation here :

https://learn.microsoft.com/fr-fr/dax/weekday-function-dax

Re: Week start day monday

jewel_at — Tue, 03 Jan 2023 14:58:09 GMT

You can create a new calculated column if you want it in DAX

IsWeekend = WEEKDAY('Table1'[Date]) IN {1,7}

Please let me know if that works!

Jewel

Re: Week start day monday

FreemanZ — Tue, 03 Jan 2023 15:20:45 GMT

hi Rahma

weekday([date], 2) shall be what you expect.

can you provide some screenshot on how:

weekday([date], 2) ===> saturday 1, sunday 2, monday 3?

Re: Week start day monday

Anonymous — Wed, 04 Jan 2023 05:39:57 GMT

HI Rahma,

I test the weekday function with option parameter 2 and it work as expected. What version of power bi desktop are you worked on? Can you please share a pbix that can reproduce the issue to test?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Week start day monday

Rahma — Wed, 04 Jan 2023 08:58:22 GMT

Anonymous i use september 2022 version

FreemanZ this is a screenshot for my dates table

jewel_at yes i created it, but the issue here is that saturday and sunday don't have the number 6 and 7 as expected. I added this column for my case

IsWeekend = IF(WEEKDAY([Date],2) in { 1, 2} ,1,0)

Re: Week start day monday

FreemanZ — Wed, 04 Jan 2023 11:03:37 GMT

hi Rahma

2019/1/1 is Tuesday, weekday of 2. What is the issue?

Re: Week start day monday

Anonymous — Thu, 05 Jan 2023 07:00:47 GMT

HI Rahma,

I check the system calendar and find the 1/7/2019 is Monday, the weekday function with option 2 in your table also get the correctly weekday number 1.(Monday to Sunday: 1~7) Why you say this function get the works with wrong result?

IsWeekend = IF ( WEEKDAY ( [Date], 2 ) > 5, 1, 0 )

Regards,

Xiaoxin Sheng