First Day of week

Hi Kbrennan856,

I hope it helps you:

https://msdn.microsoft.com/en-us/library/mt260707.aspx

Thanks,

Ricardo

Hi Kbrennan856,

You can do the SWITCH function like below:

Weekday = 
SWITCH(
    TRUE();

    "Saturday"; 0 ;
    "Sunday"; 1 ;
    ...;

    "Friday"; 6 )

I hope it helps you.

Best regards,

Hi,

thanks for your reply, here is an example of what i need

i have a date column ie 2018-02-16

and i need another column with the week number. My week no should be 7 as i use saturday as frist day of the week but dax will return me 6

Hi Kbrennan856,

You can use below formula to get Week Number from Saturday to Friday.

Calculate column formula:

weeknum =
VAR _calendar =
    FILTER (
        ADDCOLUMNS ( 'Calendar', "WeekDay", WEEKDAY ( [Date], 1 ) ),
        YEAR ( [Date] ) = YEAR ( EARLIER ( [Date] ) )
    )
RETURN
    COUNTROWS (
        FILTER ( _calendar, [Date] <= EARLIER ( [Date] ) && [WeekDay] = 7 )
    )
        + 1

Regards,

Xiaoxin Sheng