Forum Discussion

Creative_tree88's avatar
Creative_tree88
Icon for Helper V rankHelper V
1 year ago

Projected Growth based on previous two years & Displayed on Chart

Hi all - I have a dataset which looks at the last 3 years of customer numbers.  What I need to do is project these numbers and show up to the financial year 2029-30 (01 April 2029 to 31 March 2030). ...
Need Help
Creative_tree88's avatar
Creative_tree88
Icon for Helper V rankHelper V
1 year ago

GSPGSP 
burakkaragoz 
Ashish_Excel 

Thanks for all your suggestions.  I've not had a chance to get to this yet due to work pressures, but I'm starting work on this today and rest of this week.  All solutions look really great.  I'll try them all - this is such an amazing forum.  Kudos to you all!

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

     

    Hi Creative_tree88 
    Thank you for using Microsoft Community Forum.

     

    Have you had a chance to review the solutions provided by speedramps burakkaragoz Ashish_Excel,  if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

     

     

     

    • Creative_tree88's avatar
      Creative_tree88
      Icon for Helper V rankHelper V
      1 year ago

      Anonymous I'm going through them now.  It's taking a little time to apply each to my data model, but I'm slowly making my way through.  I've just asked Ashish_Excel to help with converting from Year to Financial Year, to tie up with my data.  

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Creative_tree88 Sure, thanks for letting me know.