DAX Formula

[Divya904]

Hi Experts

Please help me to write DAX calculation for this.

I want to Calculate total sales, if OrderedDate is between <[OrderDate - 90 days) and [OrderDate]

My DAX calculation is

CALCULATE (Sum'Table 1'(Sales)) , FILTER( 'Table ' , 'Table 1'[OrderDate]) in ('Table 1'[OrderDate] -90) && 'Table 1'[OrderDate]

which is incorrect. 

Thanks,

[Phil_Seamark]

Hi @Divya904

Do you just want to sum the sales for the last 90 days leading up to today?

[Divya904]

Hi Phil

Thanks for replying.

I want the Sum of sales should be equal to OrderDate.

Thanks.

Regards

[Anonymous]

I'm assuming this will be a calculated column for the table that contains a list of Order Dates

SumSales = VAR startDate = DATEADD([OrderDate], -90, day)
VAR endDate = [OrderDate]
RETURN
CALCULATE (
	Sum('Table 1'[Sales]), 
	ALL('Table 1'), 
	'Table 1'[OrderDate] >= startDate,
	'Table 1'[OrderDate] <= endDate
)