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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
abihoughton27
Helper I
Helper I

Premade Running Total Measure

Hello, i used the quick measure function to help me create a running total which works great. However I want to get the running total to be 0 until we get to that month. So July to March should have 0 value as we have not got to that month yet.

 

This is the formula which quick measure generated - now as great as it is to make the measure for me i don't fully understand it to make any changes:

 

All RT = 
CALCULATE(
	[Total per month],
	FILTER(
		CALCULATETABLE(
			SUMMARIZE(
				'Date Table',
				'Date Table'[FMonth Num],
				'Date Table'[FMonth Name]
			),
			ALLSELECTED('Date Table')
		),
		ISONORAFTER(
			'Date Table'[FMonth Num], MAX('Date Table'[FMonth Num]), DESC,
			'Date Table'[FMonth Name], MAX('Date Table'[FMonth Name]), DESC
		)
	)
)

 

abihoughton27_0-1687947473695.png

 

any help would be appreciated 

 

Abi

 

0 REPLIES 0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.