Get last quarter sales

[AppleJuice]

Hi , i need help in getting the last quarter sales amount. What is the formula for that? thanks.

Selected Month	Sales Amount	Last Quarter	Last Quarter Sales Amount
Dec-23	35000
Jan-24	$50,000	Dec-23	$35,000
Feb-24	$78,000	Dec-23	$35,000
Mar-24	$60,000	Dec-23	$35,000
Apr-24	$57,000	Mar-24	$60,000
May-24	$63,000	Mar-24	$60,000
Jun-24	$90,000	Mar-24	$60,000
Jul-24	$87,000	Jun-24	$90,000
Aug-24	$23,000	Jun-24	$90,000
Sep-24	$54,000	Jun-24	$90,000
Oct-24	$88,000	Sep-24	$54,000
Nov-24	$60,800	Sep-24	$54,000
Dec-24	$90,000	Sep-24	$54,000

[v-cgao-msft · Accepted solution]

Hi @AppleJuice ,

Please create a calendar table and try this measure:

Last Quarter Sales Amount = CALCULATE([Sales Amount],PREVIOUSQUARTER('Calendar'[Date]))

output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group