Forum Discussion
Helper VProjected Growth based on previous two years & Displayed on Chart
Helper VAshish_Excel Sorry to bother you. I am missing some years of projected growth, using the measures exactly as you sent them. Is it because my years are different to the sample data? I've gone through all the DAX and they are exactly as you detailed. My data goes up to FY24/25 - that's the last complete year, but for some reason the projected data misses FY25/26 and FY26/27 and skips to FY27/28...! I've attached an image showing you my actual numbers I'm returning. I'm really scratching my head - can you help? Otherwise it looks fantastic.
Thank you for reaching out to the Microsoft Fabric Forum Community.
Some projection years like FY25/26 and FY26/27 aren’t showing up because the DAX measure needs customer counts from the past three years to work out the midpoint growth. If even one of those earlier years is missing or blank, the measure can’t calculate the projection and just skips that year.
Thanks.I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted If yes, marking the releted solution would be awesome for others who might run into the same thing.