Which shows me this: When I add a date filter in the bar on the right it works and shows only the time where its bluegreen, but I want it to be relative so I don't have to add the dates for every campaign to every visual. I've tried other options as well, by trying to add the same min and max filter as in the first measure but with a dateadd.. but its not allowed. I've also tried with Variables but I don't think I'm doing it correctly. Also tried a slicer but it only allows 1 date collumn. And also I don't really want to slice the dates, I want it to work automatically by selecting the campaign so the people working with it can't make mistakes in selecting the right dates.
I’m confused about your requirement. How to select the right date? Do you mean filter date in visual level filter? Do you want to show the value of last year between the date you selected? I created a sample using your formula. And it was display correctly using a relative type slicer. I can’t reproduce your issue. Can you please share more details and some sample data ? then we can help you quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.