Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Rahma
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 :

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

 

1 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?

1.PNG

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.

View solution in original post

6 REPLIES 6
Rahma
New Member

@v-shex-msft i use september 2022 version

@FreemanZ this is a screenshot for my dates table

Rahma_0-1672822269147.png

@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)

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?

1.PNG

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.

hi @Rahma 

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

v-shex-msft
Community Support
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?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
FreemanZ
Super User
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?

 

 

jewel_at
Helper II
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

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors