Wk 1-3

Hi Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

Create a weeknum column.

weeknum = WEEKNUM(Sheet4[date])

Then create a measure.

Measure = var start_=1
var _end=3
return
CALCULATE(SUM(Sheet4[value]),FILTER(ALL(Sheet4),Sheet4[weeknum]>=start_&&Sheet4[weeknum]<=_end))

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.