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

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.

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.