Forum Discussion
DAX Projection Help
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.
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
