Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Hi Phil
Thanks for replying.
I want the Sum of sales should be equal to OrderDate.
Thanks.
Regards
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 )