Previous Month Error using a Measure

---

SpaceCat42 wrote:

This works and returns the correct 'current month' values:

• Current Month Value = CALCULATE(SUM(Table1[Value]),MONTH(Table1[Originated])=MONTH(TODAY()))

 

Previous Month formula calculates every row with the correct amount. However i only want the row to populate if it mets the criteria of a "prevous month." Is there a simple fix here?

 

previous month = var current_month = MONTH(TODAY()) return CALCULATE(SUM('Table1'[Value]),FILTER('Table1',MONTH('Table1'[Originated])=current_month-1))

---

Bit confusing here. As per the blue highlight, your previous month measure works fine. What is your requirement ?

Thanks
Raj