Forum Discussion

dmutka's avatar
dmutka
Frequent Visitor
7 years ago

Calendar Based on Last Date

I am trying to create a calendar in Power Bi that predicts a customers future service dates based on the last service date that we have recorded for them. I am able to create a a measure that shows t...
Need Help
Show and Tell
Tutorial Requests
MitchM's avatar
MitchM
Resolver II
7 years ago

Good morning dmutka. I took a look at the file and one challenege will be for the thrice and twice weekly customers. For example, for customer A you have Sat - Wed - Fri (which can be extrapolated as Wed - Fri -Sat), and for Customer B you have Tue - Thur. Are the service days of the week consistant? If there is no pattern then you could use the average of days between visits (every 2.3 for thrice and 3.5 for twice) to populate a table.

dmutka wrote:

Good Monring Ashish_Mathur ,

I have updated the sample to include each service frequency as well as actual servie dates for each customer that has different service frequencies. Basically the service frequency is actually based on days. So if the customer is monthly, it is 28 days apart, Every Other Month is 56, etc etc. thanks again for all your help as this resolution will really hep me out.

Updated Sample File

 

dmutka's avatar
dmutka
Frequent Visitor
7 years ago

Hello MitchM ,

the service dates are very consistent. if a customer is serviced Mon, wed, Fri, then they will be serviced those same days every week (excluding holdiays) which is an acception that I am not conerned about.

Thanks for any help that you can provide!