Solved: How to get Previous Qtr sales ?

admin11 · ‎10-15-2021

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 · ‎10-15-2021

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

New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
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 !!

speedramps · ‎10-15-2021

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 · ‎10-15-2021