User Profile
kopite833
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Re: LINESTX bugs
Suggest a better implementation of LINESTX would be... LINESTX ( <table>, <expressionY>, <expressionX>, <const>, <regressiontype>, <ouput>) Where <regressiontype> and <output> provide options user chooses, as follows... Regression type: linear, polynomial_2, polynomial_N (up to 6, like Excel), etc Output: slope(s), intercept, standarderrorslope(s), line values, other stats, etcLINESTX bugs
Using Power BI Report Server, the following issues exist for LINESTX... LINESTX does not report values in row context, so variance to Y-Axis values cannot be calculated... KnownX values must be placed in the X-Axis field well to display and evaluate the line... Polynomial regression does not appear to work... Order3PolyRegression = VAR Line = LINESTX ( ALLSELECTED ( Trade[KnownX] ), [KnownY], [KnownX], [knownY], [KnownX] ^ 2, [knownY], [KnownX] ^ 3 ) VAR Slope1 = SELECTCOLUMNS ( Line, [Slope1] ) VAR Slope2 = SELECTCOLUMNS ( Line, [Slope2] ) VAR Slope3 = SELECTCOLUMNS ( Line, [Slope3] ) VAR Intercept = SELECTCOLUMNS ( Line, [Intercept] ) VAR x = SELECTEDVALUE ( Trade[KnownX] ) VAR Result = ( x ^ 3 * Slope3 ) + ( x ^ 2 * Slope2 ) + ( x * Slope1 ) + Intercept RETURN Result
