Make Filter not applicable for Running Sum

[MKuhns01]

Creating a new calculated field as a date hider using a table calculation like so:

minOver(min({date}), [{date}])

and then filtering on this new calculated date field might be a better solution in this case.

It would allow the user to filter for any specific date time period, instead of being limited by only being able to look back in time.

I’ve read about it in this post:

How do I superimpose a period over period in a visual without having the period that I'm comparing it to in the visual?

We conceptually need to ‘hide’ those values and not filter them. To do this we will manipulate where this filter happens in the query pipeline, and by using a Table Calculation, we can make it happen all the way at the end, after the YoY calcs have already been computed. Write a calc like this: minOver(min({order date}), [{order date}]) And then put your filter on that. Should work! Before: [image] After: [image]