Forecast based on checkpoints

[TME]

Hi!

I have a table that includes: company ID, vehicle ID, contract start and end date, budgeted km driven per contract. 

Another table includes checkpoints during the contracts showing total km driven per vehicle up to the given checkpoint. 

These two tables are connected by a table containing individual vehicle IDs (as a vehicle can have multiple contracts and budgets, because the contracts can be renewed).

I would like to make a forecast calculating the expected final km figure at the end of a contract based on the checkpoints for each vehicle and contract. What would be the easiest way to go about doing this? 

Thanks in advance!

-Teemu

[v-piga-msft]

Hi @TME，

If it is convenient, could you share a dummy data sample which can reproduce the scenario, so that we can help further investigate on it? 

I would appreciate it if you could share your desired output.

Best Regards,

Cherry