Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total Sales for partial year

Hi, I have a measure "TotalSalesYTD" TotalSalesYTD = CALCULATE ( Sum(Order[Sales]), FILTER ( ALL ( 'Calendar' ), 'Calendar'[Year] = MAX ( 'Calendar'[Year] ) && 'Calendar'[Month] = MAX ( 'Calen...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    Thanks you all for your  prompt responces

     

    I was able to achieve this by using the below DAX

     

    TotalSalesIncludingPartialYear=
    Var MaxMonth = MONTH(LASTDATE(Orders[OrderDate]))
    RETURN
    CALCULATE([TotalSales], 'Calendar'[Month]=MaxMonth)

     

    Thank you all

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Thanks you all for your  prompt responces

 

I was able to achieve this by using the below DAX

 

TotalSalesIncludingPartialYear=
Var MaxMonth = MONTH(LASTDATE(Orders[OrderDate]))
RETURN
CALCULATE([TotalSales], 'Calendar'[Month]=MaxMonth)

 

Thank you all