Predictive calculations

Question

i Experts&nbsp;I need your urgent help to design a graph using the below data.&nbsp;&nbsp;ACTUAL&nbsp;&nbsp;Predictive&nbsp;&nbsp;ACCUMULATIVE COMPLETIONSACCUMULATIVE REQUESTSREMAINING RECORDSACCUMULATIVE COMPLETIONS PREDICTIVEACCUMULATIVE REQUESTS PREDICTIVEREMAINING RECORDS PREDICTIVE041292041292004129204129201878542013540135018785420135401350192574379054186481925743790541864822628448669426041226284486694260418062345756137693880623457561376938124425491679367254124425491679367254195085498979303894195085498979303894&nbsp;&nbsp;&nbsp;315085513979198894&nbsp;&nbsp;&nbsp;43508552897993894&nbsp;&nbsp;&nbsp;5439795439790&nbsp;&nbsp;&nbsp;5589795589790&nbsp;&nbsp;&nbsp;5739795739790&nbsp;&nbsp;&nbsp;5889795889790&nbsp;&nbsp;&nbsp;6039796039790&nbsp;&nbsp;&nbsp;6189796189790&nbsp;&nbsp;&nbsp;6339796339790&nbsp;&nbsp;&nbsp;6489796489790&nbsp;&nbsp;&nbsp;6639796639790The non highlighted values are precalculated and will be static at all times. The date range starting from 201908 onwards for yellow highlighted.&nbsp;The yellow color represent the predictive values, the calculation is somewhat like this,&nbsp;3 columns&nbsp;1/ Completions2/ Requests3/ Remaining&nbsp;120,000 is a predictive value.&nbsp;Completions( yellow color highlighted ), first value how its calculated(Last month cumulative+ predictive ( 120,000) )&nbsp; &gt;&nbsp; request ,&nbsp; then use request else completionsRequests&nbsp;Last month cumulative + 120,000&nbsp;RemainingRequest - Completions&nbsp;Kindly assist me on how to calcuate the last month cumulative total and how to calculate rest of the months with predictive value?&nbsp;Thanks in advance!&nbsp;

jdbuchanan71 · Answer

Hello&nbsp;Anonymous&nbsp;Are you able to share your .pbix file?&nbsp; The strucure of the model will determine the best way to answer your quesiton.A good post on getting questions answered quickly by&nbsp;Greg_Deckler&nbsp;https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

anonymous · Answer

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

Forum Discussion

Predictive calculations

2 Replies

Related content

Prediction calculation

Predictive analytics solution

Calculating predicted value

Power BI Predictive Analysis

Predictions in Power BI

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