Hi, Thanks for the solution. Unfortunately I cannot use the WEEKNUM Function because the week definiton is customized and changed according to users. Instead, i Have to use YEAR_MONTH_WEEK column (it is formated as integer).
Also the first date row, 23 Dec 2017 is intended as it is, because the date can be any, as long as it is on the date 1,8,15,23
I modified your measure, but it gives me nothing . Any advice ?