Hey Sam,
Sure. Here is what I have going…
I am starting with these formulas to create a table.
Mean (μ) = CALCULATE(average(Customer_AR_Tbl_Reciept_Date[Gross Profit - USD]),FILTER (ALLSELECTED ( Date_Tbl ), Date_Tbl[Date] <= MAX ( Date_Tbl[Date] ) ))
Stand Dev. (σ) = CALCULATE(STDEV.S(Customer_AR_Tbl_Reciept_Date[Gross Profit - USD]),FILTER (ALLSELECTED ( Date_Tbl ), Date_Tbl[Date] <= MAX ( Date_Tbl[Date] ) ))
X + 3σ = [Mean (μ)]+3*[Stand Dev. (σ)]
X - 3σ = [Mean (μ)]-3*[Stand Dev. (σ)]
Then the table I generate is from the below formula
Normal Distribution =
Var MinValue = floor([X - 3σ],1)
Var MaxValue = ceiling([X + 3σ],1)
Return
SELECTCOLUMNS(cALENDAR(MinValue,MaxValue),"X",Int([date]))
I then use this formula to generate the values to create my bell curve.
f(x) = NORM.DIST('Normal Distribution'[X],[Mean (μ)],[Stand Dev. (σ)],0)
shown in the screen shot below
When I select a different year, the (Normal Distribution’[X] values do not update with the new mean and standard deviation. How can I make this table more dynamic or is there a different way to set this up. Sorry for all of the extra information in the screen shot.