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

A01/01/2015100
A01/01/2014200
A01/01/2016300
B01/01/2015150
B01/01/2014250
B01/01/2016350
  • 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))

     

     

2 Replies

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