Forum Discussion
Projected Growth based on previous two years & Displayed on Chart
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
Ashish_Excel I think part of the issue is that my data goes beyond the last COMPLETE financial year i.e. I already have months April, May for FY25/26. I need to somehow exclude the current financial year from the DAX calculations I guess. Are you able to help please Ashish_Excel ?