Forum Discussion

DSCintra's avatar
DSCintra
New Member
3 years ago
Solved

Complete blank dates based on duration column

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!