LINEST DAX multivariate regression

[J3]

Hola, estoy intentando replicar este caso del articulo https://datakuity.com/2023/03/12/multiple-linear-regression-in-power-bi/ para una regresion multiple, pero me da el siguiente error: 

¿Como utilizar linest para regresion multiple?

[v-xinruzhu-msft · Accepted solution]

Hi @J3 

Did you create it as a calculated column or a measure, after testing , the function will return a table,it returns a table describing the line. you need to create it as a calculated table instead of a column or measure, the link you have offered, it create it as a table, you can refer to the following picture.

And you can refer to the following link.

LINEST function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.