Forum Discussion
Query Week No.
Hi good day,
Pls need assistance on my query, I want to add new column (Week No.) on my power query. I have a date column, What i need is the start of the week should be monday and end by Sunday. Pls refer below.
Thank you
6 Replies
Hi ryan_mayu thank you for the reply, but how can i make start of week count is Monday end on Sunday.
Thank you
what do you mean start of week count is Monday end on Sunday?
11/25 is Monday and 12/1 is Sunday. That week is from Monday to Sunday.
Hi AllanBerces
Many thanks to ryan_mayu for timely help.
It seems that your question is already getting the desired result. Do you have any questions?
If nothing else, you can accept it as a solution. This will help more people identify problems!
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
