Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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
@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)
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
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
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?
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
User | Count |
---|---|
20 | |
18 | |
17 | |
11 | |
7 |
User | Count |
---|---|
29 | |
28 | |
13 | |
12 | |
12 |