Excel linear forecast function equivalent to DAX

[Ivan_lopez]

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:

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.

Would anyone know how to calculate it?

Thanks in advance.

Best regards

[Ivan_lopez]

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

[lbendlin]

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

[Ivan_lopez]

a example:

the expected proyection is 21.82%

[lbendlin]

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