Complete blank dates based on duration column

[DSCintra]

Good afternoon!

I'm trying to make a calendar with some services and values in PowerBI.

In the excel sheet, i have 2 columns: start and end of the service and total value, like image below:

My ideia is to import this sheet into Power Query and turn it into a calendar like image below:

Is there anyway to do it? Fill a calendar table with the interval of service and divide the total value by the duration of service?

Thanks!

[ryan_mayu · Accepted solution]

@DSCintra 

maybe you can try use DAX to do it

pls see the attachment below

[DSCintra]

That was exactly what I need!
Thank you!

[ryan_mayu]

you are welcome