Excel linear forecast function equivalent to DAX

Question

Hello everybody!I would like to replicate the Excel function "linear forecast" on a DAX metric. I have searched for documentation on how the metric works and found this formula:&nbsp;&nbsp;I have replicated this formula on a DAX metric but it does not predict me the value for the last period, it just gives me the HIT RATIO value in that period.&nbsp;&nbsp;Would anyone know how to calculate it?&nbsp;Thanks in advance.Best regards

lbendlin · Answer

F-G Excel to DAX Translation - Microsoft Power BI Community

anonymous · Answer

This is the page where I got the formula, but I can't get it to predict the next period.

lbendlin · Answer

Please provide sanitized sample data that fully covers your issue.Please show the expected outcome based on the sample data you provided.

anonymous · Answer

a example:&nbsp;the expected proyection is 21.82%

Forum Discussion

Excel linear forecast function equivalent to DAX

4 Replies

Related content

Forecasting with DAX

DAX equivalent to the Excel Proper function

DAX SQL window function equivalent

Forecasting

Equivalent of Tableau Function: Window_sum()