--  NORM.INV returns the inverse of the normal distribution 
--  for the specified mean and standard deviation
--
--  NORM.S.INV returns the inverse of the standard normal distribution 
--  (has a mean of zero and a standard deviation of one)
--
--  https://en.wikipedia.org/wiki/Normal_distribution
DEFINE
    TABLE SampleData    = { 2, 4, 4, 4, 5, 5, 7, 9 }
    VAR Mean            = AVERAGE ( SampleData[Value] )
    VAR StandardDev     = STDEV.S ( SampleData[Value] )
    VAR Percs           = GENERATESERIES ( 0.05, 0.99, 0.05 )
    VAR CumulativeTrue  = TRUE   -- Cumulative distribution function
    VAR CumulativeFalse = FALSE  -- Probability density function
EVALUATE
SELECTCOLUMNS (
    Percs,
    "Probability %", [Value],
    "Inv. Normal Distr.",          -- Probability density function
        FORMAT (
            NORM.INV ( [Value], Mean, StandardDev ),
            "#,0.00000"
        ),
    "Inv. Standard Normal Distr.", -- Probability density function
        FORMAT (
            NORM.S.INV ( [Value] ),
            "#,0.00000"
        )
)