Target burn rate and months remaining based on burn rate

[Katie1]

Hello,

I'd like to do a simple calculation in Power BI but I think my measure is incorrect. I have monthly financial expenditures data from three countries, and each country has a budget ceiling and an end date by which to spent all funds. I would like to calculate the target burn rate for each country (i.e. the target expenditures for each month in order to fully spend all funds by the end of the project without overspending). Do you know how to structure to calculate target burn rate? I was using DIVIDE('Data'[Funds remaining], COUNTA('Program'[Months Remaining])), but it seems incorrect.

Thanks!

[Anonymous]

Some sample data with expected output will help.

Thanks
Raj