Finance Forecast using DAX Dynamic CARG

[Anonymous]

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: https://community.powerbi.com/t5/Desktop/Finance-Forecast-using-DAX/m-p/318971/highlight/false

[v-yuta-msft]

@Anonymous ,

Could you please share your sample data and expected result?

Regards,

Jimmy Tao