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 , display last qtr (JULY-SEPT sales)sales working fine :-
QTD Sales Last = CALCULATE(SUM(Sales[sales]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
 
May i know how to get previous qtr sales (APRIL-JUNE sales) expression ?
 
Paul Yeo
 
 

 

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

2 Replies

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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    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)))