DAX Projection Help

[cking2019]

Good Morning, 

I have a unique scenario I am trying to figure out. 

I have to project when a certain amount will hit 0 based off a percentage that is dynamic over time. 

EX. 

I have 217 accounts on April 27th, 2020. 

On May 1, 2020 I had 197 accounts. 

I want to project how many days it will take for the original number to 0 based off the % difference on avg of current day. Current day updates and the original number is static. 

My goal is to show a chart showing our path to 0. 

Any help or guidance it would be greatly appreciated. 

[dax]

Hi @cking2019 ,

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cking2019]

Unfortunatley I cannot share the data as it is confidential within my company however, let me explain a little bit. 

I have been tracking accounts placed on hold due to Covid-19. Now that we have begun to open our businesses I would like to forecast or project how long, what date and what percentage it will take for us to get from our peak day (Most accounts on hold) to having none. 

Below is a crude make up in excel of what we are trying to accomplish. 

I want to be able to create a chart projecting the date of 0 accounts on hold based on actual amounts of current accounts on hold and the percentage of decrease in accounts. 

Sorry if it is vague or hard to understand, im essentially trying to iterate a for or while loop projecting or an inventory forecast. But i can not seem to figure it out. 

Date	Starting #	Current Number	Change #	Change %
4/27/2020	217	205	12	6%	Avg %	5%
4/28/2020	217	197	8	4%	Avg Change	10
4/29/2020	217
4/30/2020	217
5/1/2020	217
5/2/2020	217
5/3/2020	217
5/4/2020	217
5/5/2020	217
5/6/2020	217
5/7/2020	217
5/8/2020	217
5/9/2020	217
5/10/2020	217
5/11/2020	217
5/12/2020	217
5/13/2020	217
5/14/2020	217
5/15/2020	217
5/16/2020	217
5/17/2020	217
5/18/2020	217