Forum Discussion
Solved
Trendline needed
I have a simple linechart with MonthName on the x-axis (this is derived from my own custom built calendar going from Apr to Mar as per Financial Year) and a DISTINCTCOUNT Measure of IDs for the Y axi...
I see it now. VAR Known is the name of your measure. Name your measure something else and move the VAR Known in front of the FILTER.
Slope1 and Intercept are underlined in Red (Cannot find name messages)
No need to worry about this.
You can use LINESTX or LINEST by themselves and create new tables. The table will create a single row with 10 columns. Two of those columns are Slope1 and Intercept.