Forum Discussion

Rahma's avatar
Rahma
New Member
3 years ago
Solved

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 

 

Weekday
WEEKNUM
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

6 Replies

  • jewel_at's avatar
    jewel_at
    Resolver I
    3 years ago

    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

     

     

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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?

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • Rahma's avatar
    Rahma
    New Member
    3 years ago

    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)
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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