Forum Discussion

Deva002's avatar
Deva002
Frequent Visitor
9 years ago
Solved

DAX Last Year Sales Division wise

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...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

     

    hi Deva002

     

    try with this:

     

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

     

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

 

hi Deva002

 

try with this:

 

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

 

 

  • Deva002's avatar
    Deva002
    Frequent Visitor
    9 years ago

    Thanks Victor. :)