Showing results for 
Search instead for 
Did you mean: 
aaronnayan Frequent Visitor
Frequent Visitor

Finance Forecast using DAX Dynamic CARG

Hi Guys,


I am trying to calculate a forecast using DAX and have used the approach in the link below. I am quite new to Power BI.. And want to forecast the next 5 years


I have data from 2013 to 2019 YTD, But only want the CARG to calculate from Years 2016-2018 ?.. as 2019 data is unfinshed.


Even more is it possible to go in more depth and select - 2015 April - 2016 May, 2016 April - 2017 May, 2017 April - 2018 May, 2018 April - 2019 May ?


I need your help my question is linked to:



Community Support Team
Community Support Team

Re: Finance Forecast using DAX Dynamic CARG

@aaronnayan ,


Could you please share your sample data and expected result?



Jimmy Tao




Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 281 members 3,088 guests
Please welcome our newest community members: