#### bkjohn2016

##### New Member

- Joined
- Sep 9, 2016

- Messages
- 38

Prior Month Interest Paid:=CALCULATE(SUM([Curr YTD Interest Paid]),PREVIOUSMONTH(DimDate[Date]))

Int Paid:=[Sum of Curr YTD Interest Paid 4]-[Prior Month Interest Paid]

However, in the first month of the second year the calculation results in a negative balance because month 12 has accumulated a full year of income. Any ideas?