Fun with the new LINEST / LINESTX DAX Functions...

[bvy]

I love these functions and hope to leverage them to get the slope of a best fit line over a series of data. My data table looks like this: 

Table1

DateTime	Type	Reading
Feb 3 12PM	Speed	100
Feb 5 9PM	Speed	80
Feb 7 8PM	Temp	45

Etc. 

Now I can write this DAX function to give me the slope (and other stats) of the best fit line for Speed. 

SELECTCOLUMNS(LINESTX(FILTER(Table1, Table1[Type] = "Speed"), Table1[Reading], Table1[DateTime]), "Slope", [Slope1])​

Okay, first of all, that returns a table with a single rown and single column, but it's still a table. How can I convert that to a scalar value without resorting to variables? 

Second, and more importantly, do you see an easy way for me to get slope values for EVERY Type (Speed. Temperature, etc.) without having to hard code each one in its own measure?  

Thanks. 

[LJ_Energy_Eng]

I am a bit unsure of what you are looking for. This guide uses FIRSTNONBLANK to retrieve the value from the table returned by LINEST, to make an estimation: Multiple Linear Regression in Power BI - Ben's Blog

[Padycosmos]

Hope this video helps with the concept:

https://www.youtube.com/watch?v=y42j0hpcFRc

[bvy]

Thank you. I already understand the concept. I had very specific questions about how to structure the data.