Finding Confidence Interval

[Anonymous]

Hello, I am a new user of Dax.  I need to calculate the confidence Interval(95%) based on ITEMSID  in the table.

Also, Could you please suggest the best way to plot confidence Intervals based on items. 

AuctionId	BidderID	ItemsID	BID($)
A	1	123	5
A	2	123	15
A	2	780	9
A	3	780	10
B	4	992	15
B	3	992	20
B	5	100	30
B	6	100	32
B	6	889	20
D	7	155	30
D	8	155	35
D	6	110	30
D	9	110	32

[harshnathani]

Hi @Anonymous ,

Apart from the solution above,

You can also have a look at this video 

https://www.youtube.com/watch?v=3yknTRKwDS0

and these links.

https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/

https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/

https://technicaljockey.com/microsoft-power-bi-analytics/forecast-in-power-bi/

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[lbendlin]

See this solution

https://community.powerbi.com/t5/Desktop/Confidence-Level-95/td-p/275280

and also check out this here - looks like they ported the Excel functions to DAX at some point.

https://docs.microsoft.com/en-us/dax/confidence-norm-function-dax