first day of week

[sg09]

Hi,

When filtering data on query editor , lets say applying a filter for data this week or last week, the system defines a week is from Sunday to Saturday. How can i change it so that a week is defined from Monday to Sunday ?

[elliotdixon · Accepted solution]

Hi @sg09
This was an issue for me just the other day
Looking at the DAX languate https://support.office.com/en-sg/article/WEEKDAY-Function-DAX-cadec4bc-cf24-401a-bef4-da3ab8f2cc91

If you are using a week column you need to change the <return_type> to a 1

WEEKDAY(<date>, <return_type>) should be WEEKDAY([date],1)

This makes the start of the week Monday instead of Sunday.

Rgds
ED