Forum Discussion
DAX - Running 365 Day Total
I have read through many posts on how to create a running total in DAX and thought I had the solution. To test my knowledge I manually created a table that contained two columns, a date column, and ...
I expected the total for a date to be the sum of all Quantities for the previous 365 days. So for the row with 2/15/16 as TheDate I expected the sum of all quantities between 02/15/15 through 02/15/16 which would include the following:
02/15/15 - 10
03/02/15 - 10
03/15/15 - 10
01/01/16 - 1
01/15/16 - 1
02/01/16 - 1
02/15/16 - 1
For a total of 34.
Bob