Hi, I think the best option here is to use an autonumeric for weeks, as each year can have diffrent weeks we can't use the months logic to assign consecutive numbers (Year*12+Month).
And as you are mixing differnt years it work work if you only select week, becuase ther will be different Week1, one for each year, so you'll need ,make selctings in a field that joins week and year.
You can do a load of the table where the week is, sorted by year-week, or by date and add the WeekSecuencial field, something like:
LOAD
*,
If(WeekName(DateField)=WeekName(Peek(DateField))
,Peek(WeekSecuencial)
,RangeSum(1,Peek(WeekSecuencial))
) as WeekSecuencial,
WeekName(DateField) as WeekName
Resident DataTable
Order By DateField;
DROP DataTable;
And assign values as:
='$(=Only({<WeekSecuencial={$(=Max(WeekSecuencial )-4)}>} WeekName);$(=Only({<WeekSecuencial={$(=Max(WeekSecuencial )-3)}>} WeekName);$(=Only({<WeekSecuencial={$(=Max(WeekSecuencial )-2)}>} WeekName);$(=Only({<WeekSecuencial={$(=Max(WeekSecuencial )-1)}>} WeekName);$(=Only({<WeekSecuencial={$(=Max(WeekSecuencial ))}>} WeekName)'
Not tested.
