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
nirvana_moksh
Impactful Individual
Impactful Individual

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:

 

QUARTERSYEAR.MONTHBALANCE
2017-Qtr 42017-December7000
2018-Qtr 22018-April2000
2018-Qtr 32018-August100
2018-Qtr 12018-February1000
2018-Qtr 12018-January1000
2018-Qtr 32018-July100
2018-Qtr 22018-June2000
2018-Qtr 12018-March9000
2018-Qtr 22018-May4100
2018-Qtr 32018-September500

 

And I want the end result to be:

 

QUARTERSBALANCE
2017-Qtr 47000
2018-Qtr 19000
2018-Qtr 24100
2018-Qtr 3

500

 

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

 

Thank You

1 ACCEPTED SOLUTION
nirvana_moksh
Impactful Individual
Impactful Individual

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!

View solution in original post

3 REPLIES 3
nirvana_moksh
Impactful Individual
Impactful Individual

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!

Hi @nirvana_moksh,

 

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.

Thank you for confirming!

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.