Forum Discussion
Trendline needed
Hi may I ask how did you fix that? cause i get the same error..
Anonymous
Are you talking about the red lines under [Slope1] and [Intercept]? If so, there is nothing to fix. You measure should still work without any issues. If you're getting an error when you try to create the measure then that is potentially a different issue.
Anonymous
It looks like you're using a measure at the Intercept + Slope * measure in the RETURN section. You want to use your column [Progress_date] not a measure.
Anonymous
When you use LINEST or LINESTX it creates a single row with ten columns. In the measure that I provided we are creating a variable using LINESTX. The red lines under [Slope1] and [Intercept] is becasue it doesn't recognize those as columns until you've finished creating the measure. Those variables get calculated in order from top to bottom.
yes i have the red line under Slope1 and Intercept,
but If i dont fix it its showing this error visual..
Anonymous
What do the details say?
It's saying ...🤔
Anonymous
Can you screenshot your measure?
Yes,
ok , but may I ask why there is the red line under my [Slope1] and [intercept]? thanks..