03-08-2016 04:07 AM
Re your week range always calendar weeks?
If so, the intnx() function will give you the week boundaries for the date in its argument.
So your option would be to calculate this on each data observation, or to create a look up table with these ranges (which later can use to create a format, or use for look up, joins for example).
Need further help from the community? Please ask a new question.