Create new table from results of linestx dax
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
