Week start day monday

[Rahma]

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 

[Rahma]

@v-shex-msft 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)

[v-shex-msft · Accepted solution]

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

[FreemanZ]

hi @Rahma 

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

[v-shex-msft]

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

[FreemanZ]

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?

[jewel_at]

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