Forum Discussion

Karthik_Ram's avatar
Karthik_Ram
Icon for Helper II rankHelper II
5 years ago

Forecasting DAX

Hello,

 

We use Line chart with Month in axis and Year in legend and Sales as values. Now I need to do some forecasting logic 

 

Logic: prior month sales + average % increase for each forecasted month over the last 2 years. 

 

So if we are in month of May i need to forecast for rest of year. And when we roll over to Jan 2022 it will be for whole year except Jan

 

Thanks

Need Help

14 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Share some data and show the expected result in a simple Table format.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        It does not.  I need to study the formulas in your Excel file and then translate them into the DAX language.  So share the download link of your MS Excel file.