Forum Discussion

Gezz's avatar
Gezz
Regular Visitor
4 years ago

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 =...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.

 

 

Gezz's avatar
Gezz
Regular Visitor
4 years ago

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