Calculate average cost per month between 2 dates

[hayali01]

Hi I have the following data

I would like to calculate the average cost per month [Total Cost]/Nr of Months. 

For example, the first row, is between 30th August 21 and 1st December 21. I would like to divide the total cost of £6,311 evenlY and allocate to August, September, October, November. 

I would then like the total cost per month for all the row entries and plot on a visualization. 

[amitchandak]

@hayali01 , For allocation, refer if the approach in file attached or shared blog can help

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...