Hola Josep, super util! Me ha surgido un problema a la hora de calcular el X-1sig, no entiendo porqué no aparece reflejado en la gráfica. Es decir, me calcula el valor, pero a la hora de incluir la columna junto con la media y la x+1 sig, esa columna en particular no se representa... no entiendo el por qué. Un saludo y gracias!
Great video series Josep, and super helpful. Another tweak that you can make if you want your column series to be dynamic is to create your values as measures rather than columns. You can then add your measures to column values, and for icing on the cake you can add the same measures to line series to create pronounced points along the curve. This increases readability and usability. Thanks for your series, again very helpful.
This video/tutorial is great! Many thanks, it really helped me with power bi. Do you know if it is possible to check, if the data have a normal distribution?
Hi Mercelo All data is suitable for a normal distribution, the key is how "wide" is the curve the widest curve, the spread data and opposite for a compact data. The analysis is your job. Thanks a lot for the comment!!! Josep.
Hi Josep! Great content! I have one class on statistics and made it through and technically it works. However, i used another value directly from our database (Amount of days (2 decimals) between customer order received until production needs to start). Standard deviation is 12,27 and mean is 3,02. The distribution is skewed to the right. I have no minus values in my data. +1 st. dev = 15,29 and -1 st. dev = -9,26. My slider for my data (PROACTIVITY LEVEL = GENERATESERIES(FLOOR([X-3σ];1); CEILING([X+3σ];1); 1)) have the lowest value of -34 (Floor x-3σ) and highest value 40. Now to my question, how is it possible that i get a result of 40,13% probability that customer order will arrive 0 days or less before production needs to start when my data has no minus values?
Hi infopiste!! As you can see on video, all the data is, as yours, >0, but, if Std deviation is greater than the mean, negative values should be obtained. Also, the mean on a Gauss curve, should be always at the centre of the X axis and not swewed to the right. Try to check again your steps and let me know. Good Luck!!!! Josep.
Hola Josep, me encantó tu tutorial. Estoy tratando de generar la curva pero necesito hacer saltos de 0,5 unidades en lugar de 1. No soy capaz de generar la tabla de Distribución con ese salto y eso que le pongo a FLOOR y CEILING el parámetro de 0,5 en lugar de 1. ¿Alguna sugerencia?
Hola Miguel Ángel, muchas gracias!! has probado poner 2 para la cifra significativa de las variables MinValue y MaxValue para la tabla NORMAL DISTRIBUTION que está en la Part I? Un saludo, Josep.
Usé esto pero al generar la gráfica tuve que manipular manualmente el eje "Y" Tabla Dist Normal X = GENERATESERIES(FLOOR([Mín Prom-3DesvSTD],1),CEILING([Máx Prom+3DesvSTD],1),0.2)
@@josepromero1452 Tengo un problema. Cuando creo la table de valores X, los valores estan incrementando de 1 a 1. Mi promedio es de -0.15. Cuando uso µ = IF('NORMAL DISTRIBUTION'[X]=FLOOR([Mean (μ)],1), [f(x)],BLANK()) me de un valor de -1. Preciso que me de un valor entero de -1. Me deberia dar un volor cercano a 0 ya que ese valor es donde esta el pico mas alto. Intente generar una table nueva con valores de X que incrementen cada 0.1 asi me da mayor resolucion en el grafico. Algun tip de como poder lograr eso?
Im trying to construct a LogNormal Distribution on Power BI. Example Around a Mean of 100 and a StDev of 30, the lowest is 0, thus a LogNormal Distribution ...
Hello! I'm having a problem with generating the line for µ. My IF statement is not returning a value. any help is appreciated. µ = IF('Normal Distribution'[X]= 'Performance Rating'[Mean (µ)], 'Normal Distribution'[f(x)], BLANK())
Figured it out. I had to get the formatting to match. µ = IF( ROUND('Normal Distribution'[X],2) = ROUND('Performance Rating'[Mean (µ)],2), 'Normal Distribution'[f(x)], BLANK())
Hi Josep! Great content! Could you please create next tutorial showing how to do the same but with the mean value showing correct value for different products ?
Hola Josep, super util!
Me ha surgido un problema a la hora de calcular el X-1sig, no entiendo porqué no aparece reflejado en la gráfica. Es decir, me calcula el valor, pero a la hora de incluir la columna junto con la media y la x+1 sig, esa columna en particular no se representa... no entiendo el por qué.
Un saludo y gracias!
Great video series Josep, and super helpful. Another tweak that you can make if you want your column series to be dynamic is to create your values as measures rather than columns. You can then add your measures to column values, and for icing on the cake you can add the same measures to line series to create pronounced points along the curve. This increases readability and usability.
Thanks for your series, again very helpful.
Hi Will. Thanks a lot for your comments.
I will study them deeply.
Pleased to help you!
Josep.
Excelente vídeo, información de calidad, deberías hacerlo en español, para que tan valiosa información llegue a la población hispanoparlante
Muchas gracias Hrueda01. Me lo pienso para el próximo!
Unbelived work, Thanks.
This video/tutorial is great! Many thanks, it really helped me with power bi.
Do you know if it is possible to check, if the data have a normal distribution?
Hi Mercelo
All data is suitable for a normal distribution, the key is how "wide" is the curve the widest curve, the spread data and opposite for a compact data. The analysis is your job.
Thanks a lot for the comment!!!
Josep.
Third video and still here! This is amazing!
Thanks a lot Derrick!!
Hi Josep! Great content!
I have one class on statistics and made it through and technically it works. However, i used another value directly from our database (Amount of days (2 decimals) between customer order received until production needs to start). Standard deviation is 12,27 and mean is 3,02. The distribution is skewed to the right. I have no minus values in my data. +1 st. dev = 15,29 and -1 st. dev = -9,26. My slider for my data (PROACTIVITY LEVEL = GENERATESERIES(FLOOR([X-3σ];1); CEILING([X+3σ];1); 1)) have the lowest value of -34 (Floor x-3σ) and highest value 40. Now to my question, how is it possible that i get a result of 40,13% probability that customer order will arrive 0 days or less before production needs to start when my data has no minus values?
Hi infopiste!!
As you can see on video, all the data is, as yours, >0, but, if Std deviation is greater than the mean, negative values should be obtained. Also, the mean on a Gauss curve, should be always at the centre of the X axis and not swewed to the right. Try to check again your steps and let me know.
Good Luck!!!!
Josep.
Hi,
All of that looks ok. Am i misunderstanding this or should the probability not be 0% for a value
Hola Josep, me encantó tu tutorial.
Estoy tratando de generar la curva pero necesito hacer saltos de 0,5 unidades en lugar de 1.
No soy capaz de generar la tabla de Distribución con ese salto y eso que le pongo a FLOOR y CEILING el parámetro de 0,5 en lugar de 1. ¿Alguna sugerencia?
Hola Miguel Ángel,
muchas gracias!!
has probado poner 2 para la cifra significativa de las variables MinValue y MaxValue para la tabla NORMAL DISTRIBUTION que está en la Part I?
Un saludo,
Josep.
Miguel cómo estás? Pudiste resolverlo con la solución de Josep? Estoy con el mismo inconveniente. Saludos!
Usé esto pero al generar la gráfica tuve que manipular manualmente el eje "Y"
Tabla Dist Normal
X = GENERATESERIES(FLOOR([Mín Prom-3DesvSTD],1),CEILING([Máx Prom+3DesvSTD],1),0.2)
@@josepromero1452 Tengo un problema. Cuando creo la table de valores X, los valores estan incrementando de 1 a 1. Mi promedio es de -0.15. Cuando uso µ = IF('NORMAL DISTRIBUTION'[X]=FLOOR([Mean (μ)],1), [f(x)],BLANK()) me de un valor de -1. Preciso que me de un valor entero de -1. Me deberia dar un volor cercano a 0 ya que ese valor es donde esta el pico mas alto. Intente generar una table nueva con valores de X que incrementen cada 0.1 asi me da mayor resolucion en el grafico. Algun tip de como poder lograr eso?
Hello, Could You share Your file to this bell chart? Last one not work. Thank You
Im trying to construct a LogNormal Distribution on Power BI.
Example Around a Mean of 100 and a StDev of 30, the lowest is 0, thus a LogNormal Distribution ...
Hi Alawi, were you able to construct that Distribution? I'm going to start my work on that.. Your help will be appreciated
Hello! I'm having a problem with generating the line for µ. My IF statement is not returning a value. any help is appreciated. µ = IF('Normal Distribution'[X]= 'Performance Rating'[Mean (µ)], 'Normal Distribution'[f(x)], BLANK())
Figured it out. I had to get the formatting to match.
µ =
IF(
ROUND('Normal Distribution'[X],2) = ROUND('Performance Rating'[Mean (µ)],2),
'Normal Distribution'[f(x)],
BLANK())
Hi Josep! Great content!
Could you please create next tutorial showing how to do the same but with the mean value showing correct value for different products ?