Sum of sales limiting Day(DateTimeNow()) - 1, ParallelPeriod or Limit?

Hey all, i need to create a Bar Chart that shows me how the atual month is going compared to other months limiting the Day(DateTimeNow()) - 1.


If today is day 28 of August. I need to see, in my bar chart, the Sum([Sales]) for all months (including August) until day 27.

If today is 2 of September then i need to see, in the bar chart, the Sum([Sales]) of day 1 for all months .

I've tried using ParallelPeriod and Limiting Data like Day([date_sale])=Day(DateTimeNow()) - 1, but it doesn't work.

(1) Answer