Create new table from results of linestx dax

[Ethanhunt123]

I have created a Linestx dax as - 

Revenue trend =

VAR line =

LINESTX (

ALLSELECTED('Sales order line fact'[Order month]), -- This respects the slicer

[Total revenue trend],

'Sales order line fact'[Order month]

)

VAR slope = SELECTCOLUMNS(line, [Slope1])

VAR intercept = SELECTCOLUMNS(line, [Intercept])

VAR x = SELECTEDVALUE('Sales order line fact'[Order month])

VAR y = x * slope + intercept

RETURN y

I want to create a temp table from the output that will look something like this

[bhanu_gautam · Accepted solution]

@Ethanhunt123 , Try using below

TempTable =
VAR line =
LINESTX (
ALLSELECTED('Sales order line fact'[Order month]), -- This respects the slicer
[Total revenue trend],
'Sales order line fact'[Order month]
)
VAR slope = SELECTCOLUMNS(line, [Slope1])
VAR intercept = SELECTCOLUMNS(line, [Intercept])
RETURN
ADDCOLUMNS(
SUMMARIZE(
'Sales order line fact',
'Sales order line fact'[Order month]
),
"Slope", slope,
"Intercept", intercept,
"Revenue Trend", 'Sales order line fact'[Order month] * slope + intercept
)