How to Calculate Variance (Query)

[Anonymous]

Hi, I still new to power bi. I need to calculate this table data with the variance formula, but I get an error. This is the formula and table. K=2. Initial Estimate Mean(𝜃^) = 98.93455 (I create measure = 98.93455). This is my query

Variance = POWER(SUM('Table'[Total Failures (n)])/SUM('Table'[Service Time (τ)])-('Table'[Measure]),2) / SUM('Table'[Machine(k)])-1

Variance Formula = ((n/τ)-𝜃^)^2 /(k-1)

Machine(k)           Total Failures(n)         Service Time(τ)
TEP-A                             7                            0.07884
TEP-B                             6                            0.05256

The answer should be 334.634

[DavisBI · Accepted solution]

Hi, @Anonymous ,

You can use  VARX.S()

Column = DIVIDE(Total Failures,Service Time)
Measure = VARX.S('Table','Table'[Column])

Mark this post as a solution if this helps!