Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

How to get Previous Qtr sales ?

Hi All   I have below expression , display current qtr sales ( OCT sales) working fine  :- QTD SALES = CALCULATE(SUM(SALES[sales]),DATESQTD(('Date'[Date])))   I also have below expression , dis...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    admin11 , -2  Qtr

     

    2nd QTD Sales Last = CALCULATE(SUM(Sales[sales]),DATESQTD(dateadd('Date'[Date],-2,QUARTER)))

     

    or

     

    2nd Last QUARTER Sales = CALCULATE(SUM(Sales[Sales Amount]),PREVIOUSQUARTER(dateadd('Date'[Date],-1,QUARTER)))

  • speedramps's avatar
    speedramps
    4 years ago

    Please accept this solution and also click the thumbs up icon as a thank you. Cheers

     

    QTD Sales Previous = CALCULATE(SUM(Sales[sales]),DATESQTD(dateadd('Date'[Date],-2,QUARTER)))

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Please accept this solution and also click the thumbs up icon as a thank you. Cheers

 

QTD Sales Previous = CALCULATE(SUM(Sales[sales]),DATESQTD(dateadd('Date'[Date],-2,QUARTER)))