topic linest grouping in DAX Commands and Tips

linest grouping

jshumaker — Sat, 06 May 2023 10:22:55 GMT

is it possible to return multiple rows back from a linestx function? Running one regression model at a time is not good enough as I need to have a line chart with a legend showing multiple lines at the same time

Re: linest grouping

OwenAuger — Sat, 06 May 2023 11:44:54 GMT

The LINESTX function itself always returns a single row, containing the result of a single least squares regression.

However, if you placed a particular column as the legend of a line chart, a measure that used LINESTX would carry out the regression for each value of that column.

Could you give some more detail on how you would want your visual to work along with sample data?

Re: linest grouping

jshumaker — Sat, 06 May 2023 12:36:14 GMT

here is my matrix of the data that I want to run a regression model on and a line chart of the actual values

Re: linest grouping

OwenAuger — Sat, 20 May 2023 11:20:15 GMT

jshumaker

Apologies - I was sidetracked and didn't respond to your reply!

You have likely resolved this since your last post!

I had a play around in any case. (My regression measure is probably not identical to yours)

The built-in line chart can't display two measures if a legend is included, but I created a line chart showing the y Estimate (bottom chart).

You could also use the built-in trend line regression, which should give the same result (top chart).

Hopefully this is useful if you are still looking at this.

Regards,