Forum Discussion
Slope from LINEST as new column
Hi! I need help with creating a new column in PowerBI. My data has columns for type, time and result and I need to calculate the rate for the result in new column. This is outtake fr...
This works:
LINEST A =
var a = max('Table'[Time])
var b = TOPN(5,CALCULATETABLE('Table','Table'[Time]<=a),[Time],DESC)
var c = LINESTX(b,[Time],[A])
return sumx(c,[Slope1])
but the result is most likely not what you wanted.
Hello! Can you please look into it again? I have still not figured out why the same for me gives empty column