DAX Fridays! #98: NORM.DIST | Predicting Kevin Durant Scores
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- What is the probability that Kevin Durant will score 36 PTS in the next match?
In today's DAX Fridays! We continue the Statistic Functions series with the function NORM.DIST.
Download file here: curbal.com/blo...
More on STATISTCAL DAX FUNCTIONS here:
• Statistics in Power BI
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Looking for a download file? Go to our Download Center: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
www.amazon.com...
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin: goo.gl/3VW6Ky
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#daxfridays #curbal #dax #powerbi
Hi Ruth. You had whole number selected in the parameter.
Regards
Oh thanks! I knew I was doing something wrong!
I will pin your post for more visibility!
/Ruth
Your videos has been really really helpful.. awesome work..thank you
Glad to hear!
And Happy friday!
/Ruth
hi Ruth i managed to add the 0.5 from the measure it is generated from the What if Parameter wizard and fixed the Value measure data type to decimal
Yes! Somebody told me that!!! Thanks :)
/Ruth
@@CurbalEN oh didnt see that.
thanks for the video amazing as usual :)
Thanks for watching!
/Ruth
Very nice.
Love this series 😊
Thanks Nir!
/Ruth
Excelente ejercicio de uso de los parámetros más una distribución de probabilidad!!!, muy interesante esta serie de videos, estan para enmarcarlos!!!
Ah! Gracias Norberto y buen fin de semana :)
/Ruth
You are a legend. Keep up the hard work.
Hi Ruth, I really liked this what if table, (it is like in Excel). But as for the statistics I have some remarks. First of all the question should be: what is the chance that mr. Durant scores 36 point.... or more? The result is the right part of the tail, so you should use 1 - your result. Second be carefull to ask for discrete numbers (like 36) in a continuous distribution. you should calculate the surface of 35,9999 and 36,9999. Last remark: since you have data of mr Durant, why not use this data do draw your conclusion? You could calculate how many % if the rows had actually a value of 35 or below? Interesting to compare this number with your "theoretical" distribution where you use only mean and standard deviation. I will bet they are not the same, so which one is more reliable? I would go for the real data...Greetings, Bart
Thanks Bart! I mention in the video that we will calculate below 36 and use true, but when I did that the title of the video became misleading, my fault!
Agreed on the remaining remarks , thanks for sharing :)
/Ruth
Nice and well explained!
Excellent and happy Friday :)
/Ruth
Bau saras. Dhanyavaad ben
Please post some more Video on Statistical Series. Its really awesome
I will but they require time, so they will have to wait for now.
/Ruth
Hi Ruth! wonderful explanation. can you please post the data set for this
Hola Ruth, muy buena tu comparación para poder entender tu objetivo. Saludos
Gracias Jose :)
/Ruth
Great Ruth... do we have Poisson distribution, binomial and exponential.... enjoy these a lot...
And more notes 📝 ! Awesome 😎
/Ruth
I love u Ruth! This is very helpful!!
Hi Ruth, Your presentation is statistically out of range :-), you're doing it so great! Dirk
😂😂 Thanks!
/Ruth
Thank you for the video Ruth ! One quick question - why you are using "true" for the cumulative parameter instead of "false" if you are looking for the probability the player to score 36 (2:48 and 4:44) ? According to your explanation setting the parameter to "true" will result in the probability the player to score
Yes, i Changed my mind in the middle and that has caused a lot of confusion. I am calculating
Hola Ruth, la probabilidad que calculas es de 36 o menos puntos, el complemento (1 - probabilidad) sería un mejor análisis. O en su defecto haber usado False.
Saludos y gracias por tus vídeos!
Hola Cesar, lo explico en el vídeo, pero gracias por la aclaración en caso de que no me haya explicado bien.
Saludos,
/Ruth
Would it be possible to share what the code for the [Score] Measure is please?? Really struggling to figure out what PBI will accept as that first parameter, because it's not my column of values thats for sure! Thanks!
Great! Thanks!
Bye
Bye 👋
/Ruth
Hi curbal,
Can you please let me know how to show all reports when a field selected or table selected in power BI???
Hi Ravi,
Can you check with the Power bi Community? Here is how and why:
m.th-cam.com/video/oXFOebuvRz0/w-d-xo.html
/Ruth
Hi can I get this Power BI file. It will be very much helpful for me.
Yes! I am travelling, I will post the link as soon as I am back.
/Ruth
@@CurbalEN thanks mam
Please share the link. Regards
@@CurbalEN pl share the link
Hi!
The link is on the description box, please check that out.
/Ruth
muy buen articulo, seria fabulos que compartieras la fuenta de la data o los archivos mismos, para practicar
Los comparto todos, tienes el enlace en la descripción del vídeo.
/Ruth
@@CurbalEN gracias, estoy maa ciego que un topo!
😂😂😂
/Ruth