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

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 48 members 964 guests
Please welcome our newest community members: