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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jayanthan
Helper III
Helper III

Cumulative Chart

Hi All

 

I would like to have chart where cumulative value for the current financial year (Opening balance should be added to first month and each month previous month value should be added) , please refer the below attached excel screenshot for details

 

Thanks in Advance

 

Regards

Jayanthan

 

 

Capture.PNG

Regards

Jayanthan

1 ACCEPTED SOLUTION

3 REPLIES 3
Minseven
Helper I
Helper I

try this measure:

 

Net value running total in Month = 
CALCULATE(
	SUM('TABLE'[Net value]),
	FILTER(
		CALCULATETABLE(
			SUMMARIZE(
				'TABLE',
				'TABLE'[Created on].[MonthNo],
				'TABLE'[Created on].[Month]
			),
			ALLSELECTED('TABLE')
		),
		ISONORAFTER(
			'TABLE'[Created on].[MonthNo], MAX('TABLE'[Created on].[MonthNo]), DESC,
			'TABLE'[Created on].[Month], MAX('TABLE'[Created on].[Month]), DESC
		)
	)
)

you will then have to adjust your Area Chart as follow:

 

Capture.PNG

 

reusults:

 

Capture.PNG

Hi Minseven Thank you for the reply, I have been trying this for few days, i could not recreate as you did, could you please send me a sample Pbix file, Thanks in Advance Regards Jayanthan

find an example here:

 

https://ufile.io/iu773

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.