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


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

 

which is incorrect. 

 

Thanks,

Need Help

3 Replies

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