Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated fields like EazyBI

Calculates the linear regression of a set , and returns the value of the  y -intercept in in the regression line , y = ax + b for a particular value of x.

Syntax

 

LinRegPoint(

...

Numeric_expression_

...

output_x,

...

Set_

...

expression,

...

Numeric_

...

expression y

...

, Numeric_

...

expression x

...

)

...

Arguments

Slice

Numeric_expression_

Expression

output_x

A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that
Numeric expression that represents values for the
slicer axis.
x axis function will be applied to
Set_Expression
A valid Multidimensional Expressions (
MDX
)
expression that returns a set
.
function is calculated by
Numeric_Expression_y
A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that
Numeric expression that represents values for the y
-axis.
axis function is calculated by
Numeric_Expression_x
A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that
Numeric expression that represents values for the x
-axis.
axis function is calculated by

Examples

 

See also