Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
admin11
Memorable Member
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 :-
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
 
 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

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

View solution in original post

speedramps
Super User
Super User

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

View solution in original post

2 REPLIES 2
speedramps
Super User
Super User

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
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.