I am having issues getting the right dax measure to find the cummulative total between two dates in the past. the tricky part is i need to go back a 6mth period and then get the total of the previous 6 months.
So to explain in example, in my file April 2020 would be the sum for Oct 2019 (6 mths ago) thru May 2019 (12 mths ago).
I am using a date table. I want to take selected month and get the sum for the previous 6-12 mths. I tried the following but its just not working.
VAR Sixmths = DATEADD(‘Calendar’[Date],-6,MONTH)
VAR Elevenmths = DATEADD(‘Calendar’[Date],-11,MONTH)
SUM(‘Sioux Falls’[Gross Charges]),
In the attached spreadsheet you can see for April 2020 = SUM(May19 thru Oct19)charges.xlsx (9.5 KB)
really up against time crunch so any help is VERY much appreciated.