Predictive calculations

[Anonymous]

i Experts 

I need your urgent help to design a graph using the below data.

 

ACTUAL			Predictive
ACCUMULATIVE COMPLETIONS	ACCUMULATIVE REQUESTS	REMAINING RECORDS	ACCUMULATIVE COMPLETIONS PREDICTIVE	ACCUMULATIVE REQUESTS PREDICTIVE	REMAINING RECORDS PREDICTIVE
0	412920	412920	0	412920	412920
18785	420135	401350	18785	420135	401350
19257	437905	418648	19257	437905	418648
22628	448669	426041	22628	448669	426041
80623	457561	376938	80623	457561	376938
124425	491679	367254	124425	491679	367254
195085	498979	303894	195085	498979	303894
			315085	513979	198894
			435085	528979	93894
			543979	543979	0
			558979	558979	0
			573979	573979	0
			588979	588979	0
			603979	603979	0
			618979	618979	0
			633979	633979	0
			648979	648979	0
			663979	663979	0

The non highlighted values are precalculated and will be static at all times. The date range starting from 201908 onwards for yellow highlighted.

The yellow color represent the predictive values, the calculation is somewhat like this, 

3 columns 

1/ Completions

2/ Requests

3/ Remaining

120,000 is a predictive value.

Completions( yellow color highlighted ), first value how its calculated

(Last month cumulative+ predictive ( 120,000) )  >  request ,  then use request else completions

Requests 

Last month cumulative + 120,000 

Remaining

Request - Completions

Kindly assist me on how to calcuate the last month cumulative total and how to calculate rest of the months with predictive value? 

Thanks in advance!

[jdbuchanan71]

Hello @Anonymous 

Are you able to share your .pbix file?  The strucure of the model will determine the best way to answer your quesiton.
A good post on getting questions answered quickly by @Greg_Deckler 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Thanks Updated the with data. I cannot share the PBIX due to confidentiality.