Forum Discussion
Helper VProjected Growth based on previous two years & Displayed on Chart
Solution Supplier
Creative_tree88Ashish_Excel I've tried to implement and apply your measures to my complete dataset. The only problem I'm having with it, is that I need to look at this on a financial year basis (our FY runs from 1st April to 31st March every year). At the moment, your solution is pointing to the 'Year' in the Calendar table which then makes the numbers look different to what I'm used to seeing on a Financial Year basis.
Is there any way of tweaking your measures, or a way of adding Financial Year to the Calendar Table, to tie up with my data?As always - many thanks and always maximum kudos for the solution you provided. I look forward to hearing back from you soon.
- Creative_tree88
Ashish_Excel if it helps, I've got a field in my data called 'AD_FY' which is already pre calculated to return the financial year. Not sure whether it would be better to include this in your measures / calculations or refer to the Calendar table to resolve this somehow?
- Ashish_Excel
- Creative_tree88
Ashish_Excel Thank you for this, really useful. I'm not sure how I would adjust the DAX to show projection from the last full financial year (2024-2025). I have data from financial year 2014-2015 but the last completed financial year is 2024-2025 so how would I adjust the formula to accommodate this?
Obviously, in your example the projected customer count is from 2013-2014 onwards, having had 3 years of completed data up to that point.
Just trying to clarify the DAX change to ensure my data is projected from 2024-2025.Thanks so much.
- Creative_tree88
Ashish_Excel I also just need to start projecting from the most recent completed financial year, which in this case is FY24/25 (1st April 2024 to 31st March 2025). I am really hoping you can help me solve this last piece of the jigsaw as it's very nearly there.