Forum Discussion
Bell Curve using Dax
Hi,
I have a table TTF Raw Data + Formulas Added - with a column called Average Days - I have created a measure for Mean, Median, Standard Deviation and X-3σ and X+3σ - figures below.
Mean = 52.95652174
Median = 50
Standard Deviation = 19.623
X-3σ = -5.92
X+3σ = 111.83
I would like to create a bell curve.
My next step was to create a measure for Normal Distribution e.g. NORM.DIST(X, Mean, Standard_dev, cumulative. But this is where I get stuck - any help is appreciated.
8 Replies
- lbendlin
Super User
You have your six sigma boundaries. First step is to map these out it in a new table ( or data from an existing table. Curious how you can have negative TTF though )
Table = GENERATESERIES(-10,120)Next you add a calculated column that computes the normal distribution
ND = NORM.DIST([Value],52.956,19.623,FALSE())Last step is to plot it in a line chart or column chart.
TTF is average time to fill -5.92 is -3 standard deviations from the mean. It's not an actual data point. 52.95 is mean - 19.62 is standard deviation. 52.92 -3*19.62.
I have a column that I have calculated which is =networkdays in the Excel spreadsheet. That gives me my average days for each job. I've then calculated mean, median, standard deviation from that. If there's a way to auto calculate that from dates alone that would help when uploading a new report
Hi Inbendlin
Thanks for your help.
I created a table using GENERATESERIES and a Calculated Column.
I have a Table with one column from with numbers -5 through to 120 and the another with the distribution values for these figures. The -5 through to 120 are the range in which all of the average days values fall within. I need the distribution values for the unique figures in my Average Days column.In below example you have the unique student scores and the distribution for each one - I need to do that with Average Days through DAX.
I was trying to use DAX to add TFF + Forumlas Added [Average Days] as another column in the table but wasn't able to.
Any suggestions?
- lbendlin
It is not clear to me what your expected outcome is. I can not help you without usable sample data. Screenshot are not usable.
