Forum Discussion
spandy34
Responsive Resident
Responsive ResidentDate Table 12 week period
I have a Date Table which in the 12 Week Period Column creates a new period for every 12 weeks as per the column highlighted. What the 12 Weeks Period is doing through is going back to 1 at the begi...
Hi - yes I did. I created the following 12 Weeks Period column as suggested.
12 Weeks Period = ROUNDUP(DIVIDE('Procurement_Planned_Visit_Date'[WeekNo]+1,12),0)The column included the WeekNo column. The WeekNo was initially"WeekNo", WEEKNUM( [Date] ),But I changed the WeekNo column to the following and it has worked so I now get continuous week numbers"Week No", QUOTIENT( datediff(minx(_tab, [Date]),[date],day) ,7)So now the 12 Week Column covers multiple years if you look at the CalYear column below.
Hi spandy34 ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Yilong Zhou
spandy34Responsive Resident
Responsive ResidentHi - yes I did. I created the following 12 Weeks Period column as suggested.
12 Weeks Period = ROUNDUP(DIVIDE('Procurement_Planned_Visit_Date'[WeekNo]+1,12),0)
The column included the WeekNo column. The WeekNo was initially
"WeekNo", WEEKNUM( [Date] ),
But I changed the WeekNo column to the following and it has worked so I now get continuous week numbers
"Week No", QUOTIENT( datediff(minx(_tab, [Date]),[date],day) ,7)
So now the 12 Week Column covers multiple years if you look at the CalYear column below.