Average, SD and variance of production time of products

[Dicko]

I have a column Products[Number of Days] with the time it takes to produce a product.
Some products don't have a value for this.

Now I have a visual:
X-axis: Number of Days
Y-axis: Count of Number of Days

I have for example 9 products that take 20 days to produce, and 62 products that take 50 days to produce.

How can I calculate the average, the standard deviation and the variance of the number of days it takes to produce products?

I don't think it's just as simple as Average = AVERAGE(Products[Number of Days])

Any help is appreciated!

[v-janeyg-msft]

Hi, @Dicko 

Can you provide more details about your data? Without knowing the data, it is difficult for us to provide specific solutions
If it is possible, please upload some insensitive data samples and expected output, so we can help you soon.

Reference:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,

Community Support Team _ Janey

[amitchandak]

@Dicko , if the number of days is a column avg should do

AVERAGE(Products[Number of Days])

if this is a measure then

AVERAGEX(values(Products[product]) , [Number of Days])

for standard Dev

refer

https://dash-intel.com/powerbi/statistical_functions_stdev.php