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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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