# LinRegPoint

Calculates the linear regression of a set and returns the value of y in the regression line y = ax + b

## Syntax

LinRegPoint(Numeric expression output x, Set expression, Numeric expression y, Numeric expression x)

## Arguments

Numeric expression output x | Numeric expression that represents values for the x axis function will be applied to |
---|---|

Set expression | MDX expression that returns a set function is calculated by |

Numeric expression y | Numeric expression that represents values for the y axis function is calculated by |

Numeric expression x | Numeric expression that represents values for the x axis function is calculated by |

## Examples

Following example shows Remaining Story points tree over Time per Sprint period.

LinRegPoint( -- Numeric expression output x DateToTimestamp([Time].CurrentHierarchyMember.StartDate), -- Set expression - input period Filter([Time].CurrentHierarchyMember.Level.Members, [Measures].[Time within Sprint] > 0), -- Numeric expression input y [Measures].[Story Points remaining], -- Numeric expression input x DateToTimestamp([Time].CurrentHierarchyMember.StartDate) )