bkjohn2016
New Member
- Joined
- Sep 9, 2016
- Messages
- 38
I have two years of income data and unfortunately, my data source does not have the month to date data I need. I've resorted to calculating the month to date income with the following formulas:
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?
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?