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

Check out the April 2026 Power BI update to learn about new features.

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.