Forum Discussion

Divya904's avatar
Divya904
Helper III
8 years ago

DAX Formula

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 CALCUL...
Need Help
Divya904's avatar
Divya904
Helper III
8 years ago

Hi Phil

 

Thanks for replying.

 

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

 

Thanks.

 

Regards

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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
)