Group by Weeks

[spandy34]

Hello

I have a Date Table and I would like to create a column named Qtr/Weeks which groups the Week Nos by 12 , so each Qtr Week contains 12 weeks ie

Qtr/Weeks          WeekNo

1                            0-11

2                           12-23

3                           24-35

4                           36-47

5                           48-52

Can someone please tell me how to create this column in the table below.

Many thanks

@v-heq-msft @Greg_Deckler @danextian @tamerj1 @goncalogeraldes 

[danextian · Accepted solution]

Hi @spandy34 ,

Please try:

[spandy34]

That is brilliant. It worked.  Thank you very much @danextian 

[spandy34]

Could this be done by creating the new column if I grouped by every 6 weeks instead of every 12 weeks ?

[lbendlin]

Quarters and weeks are incompatible. Use an external static reference table that clearly identifies the quarter and the week number for every single day.

[spandy34]

Could this be done by creating the new column if I grouped by every 6 weeks instead of every 12 weeks ?

[lbendlin]

Not sure what you mean. Please elaborate.

[spandy34]

I just want a new column that says :

if the Week No column is between 1 and 11 then 1

if the Week No is between 12 and 23 then 2

if the Week No is between 24 and 35 then 3 and so on