Previous Month Measure Value

Anonymous — Thu, 03 Oct 2019 05:13:53 GMT

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.

topic Previous Month Measure Value in Developer