I have tried your solution but am running into an issue. My dates are not by month like your but rather by week. Is there a way to update your formula to account for this? Also, i am trying to look at the data in a slicer by Last 4 Wks, Last 12 Wks, Last 26 Wks, Last 52 Wks, MTD and YTD periods.
Thanks for any help you can provide. I have been trying to figure this out for a while not.
I dont think its possible to calculate a column based on a sliver value. I have been looking for a solution but unable to find one.
I have been wanting to sum the sales for the past 12 months based on a slicer selected date and cannot find a slution anywhere,