topic Re: Create new table from results of linestx dax in DAX Commands and Tips

Create new table from results of linestx dax

Ethanhunt123 — Fri, 06 Sep 2024 12:00:49 GMT

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

Re: Create new table from results of linestx dax

bhanu_gautam — Fri, 06 Sep 2024 13:01:25 GMT

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
)