Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

 

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

    Could you please share your sample data and expected result?

     

    Regards,

    Jimmy Tao