Query Week No.

[AllanBerces]

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

[Anonymous]

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.

[ryan_mayu · Accepted solution]

@AllanBerces 

you can try 

=Date.WeekOfYear([date])

[AllanBerces]

Hi @ryan_mayu thank you for the reply, but how can i make start of week count is Monday end on Sunday.

Thank you

[ryan_mayu]

@AllanBerces 

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. 

[AllanBerces]

Hi @ryan_mayu, yes something like below

Thank you

[ryan_mayu]

your screenshot is the same as mine. Did I solve your question? If so, pls accept my answer as a solution.