accrualexample.png

I am trying to write a report to determine revenue accruals by month based on the start and end dates above. The above is an example of the data set I am working with. This requires comparing four calculations of the number of days that span the month based on the start and end dates.

My biggest issue is with automating how to calculate the $ in the opening month. For example, 4 days occur in August in line 1, so 4 days’ worth of tuition ($26.24 out of the $1,200) is recorded in the "August Earned" column.
I am looking for advice on the best way to accomplish automating this through any of the following:

1) Excel Formulas;
2) DAX formulas; OR
3) PowerQuery features/functions/formulas

Any help would be greatly appreciated.