Forum Discussion

Karthik_Ram's avatar
Karthik_Ram
Helper 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

14 Replies

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User

        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.