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
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi Divya904

 

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

  • 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
)