Find week (custom time dimension) from date in import
I'm working on a model which has a month format in my time dimension, this is nessecary because of workspace restrictions. But there is a need to add FTE using a begin and end week, so I've constructed a custom time dimension which looks like this:
The weeks are genererated and are given a begin and end date in the same proces.
In my import file I have transactional data, so I have a date on which a certain amount of hours are written. Looking like this:
I would like to connect the date to a week using my beginning and end-date connected to my weeks. So the first record has the date 15-02-2017, which I would like to connect to week 7 2017.
I tried several things, but I just can't seem to get the correct formula(s). I hope someone can help my along.
Thanks in advance for your help.
René den Uijl