Hi guys,
I have an issue that I feel is probably really simple to overcome but it's been testing my patience for a while.
Basically, I have a custom calendar table that categorises certain weeks as week 1, 2, 3, etc. based on my company's classification.
E..g.:
Now, I have another dataset that is populated with dates and I want to link those dates to reference my custom week numbers.
Basically I want to insert a new Column, simply called Week Number, next to the dates in my other dataset that will recognise which of my custom Week Numbers that date should fall into.
For example:
So my second datasets are now referencing the Week Number they fall into based on my custom calendar, if that makes sense.
Is this possible - is there an even easier way of linking the two that I'm missing?
Thank you for any help!
I have an issue that I feel is probably really simple to overcome but it's been testing my patience for a while.
Basically, I have a custom calendar table that categorises certain weeks as week 1, 2, 3, etc. based on my company's classification.
E..g.:
| Week Commencing | Week Number |
01/08/2020 | 1 |
08/08/2020 | 2 |
15/08/2020 | 3 |
22/08/2020 | 4 |
29/08/2020 | 5 |
05/09/2020 | 6 |
12/09/2020 | 7 |
Now, I have another dataset that is populated with dates and I want to link those dates to reference my custom week numbers.
Basically I want to insert a new Column, simply called Week Number, next to the dates in my other dataset that will recognise which of my custom Week Numbers that date should fall into.
For example:
| Client Completion Date | Week Number |
04/08/2020 | 1 |
12/10/2020 | 11 |
07/01/2021 | 23 |
29/11/2020 | 18 |
So my second datasets are now referencing the Week Number they fall into based on my custom calendar, if that makes sense.
Is this possible - is there an even easier way of linking the two that I'm missing?
Thank you for any help!
