cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cbtekrony
Helper IV
Helper IV

Projections Using Avg Growth %

I am computing future growth with this DAX:

 

PROJECTED GRWTH  AVG YOY CHANGE=
VAR vCurYear =
CALCULATE ( YEAR ( MAX ( 'Table'[Process Date] ) ), ALL(' Table') )
 
VAR vCurYearSales =
CALCULATE ( SUMX ( 'Table', 'Table'[ACV+YTD Est.DD] ), 'Calendar Table'[Year] = vCurYear )
 
VAR vYearIncrement =
MAX ( 'Calendar Table'[Year] ) - vCurYear
 
VAR vProjGrowth =
vCurYearSales * POWER ( 1 + [YoY Avg. Change], vYearIncrement )
 
VAR vResult =
IF ( MAX ( 'Calendar Table'[Year] ) <= vCurYear, BLANK (), ROUND ( vProjGrowth, 0 ) )
 
RETURN
vResult
 
The forecast result I'm getting is the total of vCurYearSales  for each future year. If I plug in the "hard" number instead of my measure [YOY Avg Change] above, I get the correct forecast.  But of course, the point of DAX is to have dynamic results. 
Why can't I use my measure [YOY Avg Change] to compute this?
 

Power BI.jpg

1 REPLY 1
v-kelly-msft
Community Support
Community Support

Hi @cbtekrony ,

 

Could you pls provide a sample .pbix file for test?Remember to remove confidential information inside.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.