Forum Discussion
Unable to reference LINESTX table output using SELECTCOLUMN
UPDATE: sample file here. Look at the DAX Query View. I'm developing a calculation item, but using the DAX Query View for testing purposes.
I have stored the output of a LINESTX function (which is a table) in a variable:
// Calculate regression line based on measureTable
VAR line = LINESTX( measureTable, [Y], [X], TRUE)
This outputs a table of values as expected:
However, when I try to extract specific values from that table using "SELECTCOLUMNS", the columns [Slope1] and [Intercept] are not recognized:
Does anyone have any idea what I might be doing wrong?
It appears there is a bug in the DAX editor. When I view the calculation item in Tabular Editor, it doesn't contain an error. See if you can use the calculation item successfully.
5 Replies
Try adding the name of the new column:
VAR slope = SELECTCOLUMNS ( line, "Slope1", [Slope1] )Same result:
It appears there is a bug in the DAX editor. When I view the calculation item in Tabular Editor, it doesn't contain an error. See if you can use the calculation item successfully.
