cancel
Showing results for
Did you mean:
Memorable Member

## 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 :-

May i know how to get previous qtr sales (APRIL-JUNE sales) expression ?

Paul Yeo

2 ACCEPTED SOLUTIONS
Super User

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

New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!
Super User

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

2 REPLIES 2
Super User

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

Super User

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

New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Announcements