Need to work out Estimated Date of Completion

[Anonymous]

I have data like this :

Date       Complete

05/11/2020	1
01/12/2020	1
02/12/2020	2
04/12/2020	1
07/12/2020	2
08/12/2020	4
09/12/2020	3
10/12/2020	6
11/12/2020	5
14/12/2020	6
15/12/2020	18
16/12/2020	4
17/12/2020	5
22/12/2020	6
05/01/2021	4
07/01/2021	3
08/01/2021	6
11/01/2021	9
12/01/2021	15
13/01/2021	11
14/01/2021	9
15/01/2021	12
18/01/2021	16
19/01/2021	19

There are 1120 inspections needed to be done, so I created a measure called "Target=1120"

I also have a Measure for RunningTotal using the Done column.

I need to work out the Estimated Date (Month) of completion (to reach the Target value).

I want to put together a simple report showing the current progress and estimated time of completion.

Anyone know how I can calculate this? And display it?

[v-jingzhang]

Hi @Anonymous 

Your expected result is not very clear. What does the Complete column mean in the data? What is the logic to get the Estimated Date of Completion? You may find this post helps: How to Get Your Question Answered Quickly

Regards,
Community Support Team _ Jing