Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |