topic Re: Excel linear forecast function equivalent to DAX in DAX Commands and Tips

Excel linear forecast function equivalent to DAX

Anonymous — Mon, 02 Jan 2023 12:23:23 GMT

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

Re: Excel linear forecast function equivalent to DAX

lbendlin — Mon, 02 Jan 2023 23:11:17 GMT

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

Re: Excel linear forecast function equivalent to DAX

Anonymous — Tue, 03 Jan 2023 16:39:05 GMT

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

Re: Excel linear forecast function equivalent to DAX

lbendlin — Tue, 03 Jan 2023 17:23:26 GMT

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

Re: Excel linear forecast function equivalent to DAX

Anonymous — Wed, 04 Jan 2023 10:17:24 GMT

a example:

the expected proyection is 21.82%