cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## First Day of week

Hi,

My week runs Saturday to Friday,

is there a way in dax i can get the week no and year? as currently i only have the option in dax for Sunday to monday

5 REPLIES 5
Highlighted
Continued Contributor

## Re: First Day of week

Hi @Kbrennan856,

I hope it helps you:

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

Thanks,

Ricardo

Resolver I

## Re: First Day of week

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,

Highlighted
Frequent Visitor

## Re: First Day of week

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

Highlighted
Resolver I

## Re: First Day of week

Hi,

You can include one column with weekday_name, then to do the SWITCH function based on the weekday_name.

I hope it helps you.

Best regards,

Highlighted
Community Support

## Re: First Day of week

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

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors