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.
I need to check if a value is greater than the value of the previous month, these values are in a year / month dimension matrix.
I already tried the calculation Test = CALCULATE ([Vlr Expenses]; PARALLELPERIOD (LASTDATE ('Calendar'); - 1; MONTH)), but did not work.
Hi @Jacy,
Could you post your table structures with some sample data which can help us reproduce the issue, so that we can help further investigate on it?
It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Regards
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.