Forum Discussion
Calculating Prediction Intervals in Power BI
I have a set of measures that generate a quadratic regression model for a set of data. The final piece I'm looking for is a prediction/confidence interval around each predicted term. Ideally, this in...
im not sure if you can create a quadratic regression with dax.
you can check this article from sqlbi if maybe it can help you.
https://www.sqlbi.com/articles/implementing-linear-regression-in-power-bi/
another thing to note, you can create visuals with python code.
so maybe this is more appropriate for you ?
I've definitely performed the regression proper, as I've confirmed using R that my calculations of the coefficients are correct. The issue I'm having is with calculating the prediction interval. There are DAX formulas such as CONFIDENCE.T that supposedly provide the necessary pieces to calculate upper/lower bounds on a prediction, but I've had no success emulating what is output from R.