Forum Discussion
Data for days which are not present
Hi all, I need a help regarding the date selection for the date/months which are not present in the original data source. I have been working on a Dashboard which has details about the rental perio...
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi thanish
Yes this is possible. What value would you like to be shown for Feb, Mar, April, May and June in this case?
Hi Phil, thanks for the response. I have used a formula to calculate the overall rental period which is the difference between the collection date and delivered date as you can see in the below date. When I plot the bar chart I wanted the total number of days it has been utilized for a particular month and % utilization too(which I think will work once the days are there). Right now it automatically extracts the days for the particular month and not for the months that are not present in the created date. Your help is appreciated. Thanks