Forum Discussion
LINEST DAX multivariate regression
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?
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.
1 Reply
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.