Your Date>=DATEADD('year',-1,Date(Datetrunc('month',TODAY())) and Your Date <=DATEADD('year',-1, TODAY())
You can use this in your Calcs to Get MTD for Last Year
thank you, it worked!
Sorry to bother you again.
Now, I have used the formula:
Validation Filter: DATEPART('month',[Date])<=DATEPART('month',[Max Date in Data Set])
in order to display information only up until the month that I have new data as you can see below.
As you can see, August data for 2017 is the total sales for that month and I want to now take that MTD for last year that you calculated, and apply it to this graph. Is this possible? Thank you so much
Red highlight: TOTAL Aug 2017 sales
Blue highlight: MTD Aug 2018 sales (contains sales only up until Aug 13th 2018)