cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Week start day monday

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 :

1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
6 REPLIES 6
New Member

@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)``
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

hi @Rahma

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

Community Support

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?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

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?

Helper II

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors