cancel
Showing results for
Did you mean:
Established Member

## Value of Last Month of Every Quarter

Hello All,

I have been struggling with this for the past couple hours, I thought I had it till I realized I did not. What I am trying to achieve is to grab the value from the last month of every quarter and display only that in a chart, instead right now my SUM(Balance) shows the sum of all months within that Quartr. My data is like below:

 QUARTERS YEAR.MONTH BALANCE 2017-Qtr 4 2017-December 7000 2018-Qtr 2 2018-April 2000 2018-Qtr 3 2018-August 100 2018-Qtr 1 2018-February 1000 2018-Qtr 1 2018-January 1000 2018-Qtr 3 2018-July 100 2018-Qtr 2 2018-June 2000 2018-Qtr 1 2018-March 9000 2018-Qtr 2 2018-May 4100 2018-Qtr 3 2018-September 500

And I want the end result to be:

 QUARTERS BALANCE 2017-Qtr 4 7000 2018-Qtr 1 9000 2018-Qtr 2 4100 2018-Qtr 3 500

I tried using ENDOFQUARTER but that did not return my intended result.

Thank You

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: Value of Last Month of Every Quarter

I think I figured it out by using CALCULATE(SUM(BALANCE), ENDOFQUARTER(DATE)). let me know if someone else handles it better and in a different manner.

Thanks!

3 REPLIES 3
Established Member

## Re: Value of Last Month of Every Quarter

I think I figured it out by using CALCULATE(SUM(BALANCE), ENDOFQUARTER(DATE)). let me know if someone else handles it better and in a different manner.

Thanks!

Community Support Team

## Re: Value of Last Month of Every Quarter

By my research, I'm afraid your formula should be the most simple.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Established Member

## Re: Value of Last Month of Every Quarter

Thank you for confirming!

Announcements