DAX Last Year Sales Division wise

[Deva002]

How to add a calculated column for the last year sales for the same month divison wise?

DivDateSales

A	01/01/2015	100
A	01/01/2014	200
A	01/01/2016	300
B	01/01/2015	150
B	01/01/2014	250
B	01/01/2016	350

[Vvelarde · Accepted solution]

hi @Deva002

try with this:

LastYearSales = CALCULATE(Sum(Sales[Sales]),ALLEXCEPT(Sales,Sales[Div]),DATEADD(Sales[Date],-1,YEAR))

[Deva002]

Thanks Victor. 🙂