User Profile
Vickyswe
Copper Contributor
Joined Feb 21, 2022
User Widgets
Recent Discussions
LINEST() function calculation
Hi, I'm working on a requirement where I try to replicate a scatter graph with a trendline from Excel to Power Bi. Can someone explain the underlying calculation of the LINEST() function, what kind of calculation it does with the data when we give known Y's and known X's when set const parameter as false. LINEST( known_y's, [known_x's], FALSE ) The resultant of the above equation gives the adjusted slope value setting the intercept as 0. It would be useful if I get to know, how the slope is corrected.1.6KViews0likes1Comment
Recent Blog Articles
No content to show