Rolling 90 Day Total

[Capt.Ragnar]

I've tried to apply examples that I found here and elsewhere to no avail. Below is the DAX formula I've attempted without success...

90DaysAmount:=CALCULATE(SUMX(Table1,[Amount]),FILTER(ALL(Table1),Table1[Time ID]>=MAX(Table1[Time ID])-3&&Table1[Time ID]<=MAX(Table1[Time ID])))

What you need to know about the time component is that data is only reported monthly. So each number value in the Time ID table is reflective of a month and a year.

Ex.

[TABLE="width: 200"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Month[/TD]
[TD]Year[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jan[/TD]
[TD]2013[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Feb[/TD]
[TD]2013[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Mach[/TD]
[TD]2013[/TD]
[/TR]
</tbody>[/TABLE]


I'm trying to calculate the 90 day volume for each location in my pivot. The formula above results in the same total for every location.

 

[Capt.Ragnar]

I think you're right. I'm trying to effectively create base units and filter them in the same code to reduce creating additional columns in my dataset. It never occured to me to create the calc without using a Calculated Column.

I see were you are headed. Let me see if I can get it to work.

I really need to take a class on this stuff. New to it only a couple of months ago...