Forum Discussion
DSCintra
3 years agoNew Member
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!