Calculate an repeating average value to create a linear average line

amitchandak Thank you 🙂

Your second measure shows me the same average value (35) for every date, which is very good.

But I have a measure (measureA) in the calender, which determines the date until the last calender week. In the Filter panel I excluded additionally - by using measureA in the filter panel - the dates before 2021. 

Now, with your solution I have the 35, but I have also all Dates from my calender after the last full calender weak (the filter date < -2021 in the filter panel still works) . Therefore, the measureA ist not any more active if I use "ALLSELECTED(calendar)" at the end.

I hope I you can understand what I mean :D. Sincerely, I cannot upload data from company-account.