1 of 1 people found this helpful
The above calculation should work by adding a couple of aggregations to it.
You might also prefer to use the window_max function, as opposed to running_max
IF attr([Date])>DATEADD('week',-52,WINDOW_MAX(Max([Date]))) THEN sum([Sales]) END
Hope this helps!