Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Above measure working fine for me. Try this measure on separate data.
Are there any filters applied ??
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
Year Y+1
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.