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
El_LukosDBS
New Member

Previous month calculation not working for january

Hello guys, I'm pretty new to PBI and I have a Previous month measure that doesn't work for january

MoM% = 
IF(
	ISFILTERED('Requête2'[DATE VOL]),
	ERROR("ERREUR"),
	VAR __PREV_MONTH =
		CALCULATE(
			[Nombre bookings],
			DATEADD('Requête2'[DATE VOL].[Date], -1, MONTH)
		)
	RETURN
		DIVIDE([Nombre bookings] - __PREV_MONTH, __PREV_MONTH)
)

Any help is welcome 🙂

 

Best regards

3 REPLIES 3
rautaniket0077
Resolver I
Resolver I

Above measure working fine for me. Try this measure on separate data. 

Are there any filters applied ?? 

rautaniket0077
Resolver I
Resolver I

How many times january is appearing in your data and for which january its not showing.
please provide the sample data like whats happening right now versus what you want.

Hello, I can't share my data due to organizational policy but I'll provide screenshots

Year Y

El_LukosDBS_0-1680528387702.png

Year Y+1

El_LukosDBS_1-1680528503009.png

As you can see, Year Y MoM% should show no value as there is no value for precedent year, and year Y+1 should show the difference between December Y and January Y+1

 

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.