Pro-ration of cost based on two date columns

Can you please help me split the cost as per month?

I want to get a unique list of circuits and split the cost per month, with circuits in the rows and months in the columns.

The problem arises when the start date and the end date are in different months.

Please check the file for more details.

Thank you very much.
Sample.xlsx (11.6 KB)

Bumping this post for more visibility from our experts and users.

Hi @aheller,

We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and xperts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!

In light of this, we will be closing this thread, but we invite you to start a new thread with updated details so that our experts can better assist you.

Thank you for being a part of our community, and we hope you find the help you need.