How to get Previous Qtr sales ?

[admin11]

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

[amitchandak · Accepted solution]

@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 · Accepted solution]

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 · Accepted solution]

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