Last 4 weeks data

Hi,

Thank you for this solution.

I have a simalar problem, I'll try my best to explain.

I want to present the weekly measures of the 4 last weeks, the only difference is the I want it to be filtered by a slicer- to show only the 4 weeks back from the date on the slicer. (that the last week presented would be the date on the slicer, that it would be moving).

in my data I have both weekly and rolling 28 (4 last weeks) aggregated data.

I have a slicer of dates called 'period ends on', and I want it to show the 4 last weeks according to the slicer.

How can I do it?

Thanks a lot,

Liron