How to calculate MonthStart to Today + LYMonthToday to MonthEnd?
For this calculation, I need the data from the current month's first day to current day, plus the data from last year of the same month and day until the end of the month. It cannot be static, meaning when the current date changes, so must the aggregation of the data sets.
For example, (December 1, 2017 - December 13, 2017) + (December 13, 2016 - December 31, 2016)
And in a week (December 1, 2017 - December 20, 2017) + (December 20, 2016 + December 31, 2016)
I currently have two variables to represent the two sets of criteria