Forum Discussion
Creative_tree88
Helper V
1 year agoProjected 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). ...
Ashish_Excel
Solution Supplier
1 year agoCreative_tree88
Helper V
1 year ago
I'm having issues with the projection - it's not tying up with the last date of my actual data, to then project FROM that period (last complete financial year). See image:
This is further compounded when I select a sub category, related and linked to the main data (see image below):
I'm guessing some sort of tweak of the DAX but I'm not sure how, or what I need to tweak to rectify.
Ignore the 'count ALL Demand' as this is how I've labelled that particular measure, rather than count customers. It's the same measure though.
Thanks Ashish_Excel