Previous Month Measure Value

Hi All,

I am trying to get previous month value of a measure but not able to.

I have used following options already but none of them worked for me. What am I missing?

CALCULATE(DISTINCTCOUNT('ALL INCIDENTS'[INCIDENT_ID]), PREVIOUSMONTH('FALL INCIDENTS'[INCIDENT_DATE])) This is giving me same value as current month.

CALCULATE(DISTINCTCOUNT('ALL INCIDENTS'[INCIDENT_ID]),PARALLELPERIOD('FALL INCIDENTS'[INCIDENT_DATE]),-1,MONTH))

CALCULATE(DISTINCTCOUNT('ALL INCIDENTS'[INCIDENT_ID]), DATEADD('FALL INCIDENTS'[INCIDENT_DATE]),-1,MONTH))

I also tried using Date from my Calendar table but same result. Please help.

0 REPLIES 0

Helpful resources

Announcements

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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

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.