DAX Fridays 160: Random SAMPLE using DAX
HTML-код
- Опубликовано: 12 сен 2024
- Here you can download all the pbix files: 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
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/pro...
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
I was really unaware of it. I'm used to work with large tables and doing data shuffling to get a meaningful and more manageable sample using PQ was the only way I was aware of. I'll give it a try. Thanks Ruth!
Awesome, give it a try :)
/Ruth
Thank you Ruth for the good work always.
This is really great explanation Ruth 🙂. It's really useful for the consumer insights projects where we require sampling to send the surveys bases on KPIs... Thanks a lot once again 🎉🎉🎉🎉
Cool use case, never thought of it:)
/Ruth
@@CurbalEN it's really great use case for my project actually never thought and did research about it.
Thank you, I'm from Brasil and this was very usefull at my work today!
Thanks Ruth. This is a good one and very helpful when we are with very large scale data tables. Thank you
It is :)
/Ruth
Hi Ruth, thank you for this tutorial. It is actually very useful ! I would like to know if there is a way to generate a list of unique and non repeting values with a function like RAND. The generated values must be unique because in my report, I am trying to guide users to refresh in order to see a new random product of the list with a what if parameter. Thank you.
Zaanse koeken, are Dutch biscuits (from beginning of 19th century). Originally from Zaandam, made by Verkade factories.
Thank you for sharing your indept knowledge, was helpfull.
Not really the sampling i'm looking for, but i understand the logic how it works now.
Upon further inspection, what the SAMPLE() method does is "Systematic sample" and not "Random sample". But perhaps for the majority this doesn't really matter. I was searching for a "Random sample". But you explained it very well, so very helpful still, title and some narrative may be misleading though:). You could potentially convert it in "Random sample" i believe if you add some randomness to the order, but without that it will be "Systematic sample".
First create column with = RAND()
Then order by that column and create the SAMPLE()
Hei you describe very well! I love your teaching skills
My mum was a teacher, maybe I got her gene ;)
/Ruth
😀
thanks ruth please upload more examples on DAX functions it will be very useful to understand more clearly each function again thnak you for such valuable videos
I dont have a lot to cover anymore, mostly the basic ones. Maybe so practical examples again.
/Ruth
THANK YOU SO MUCH! Do you know of any way to regenerate the sampling, lets say I need a new sample every week? Is our only option to repeat this process everytime? :)
Hi Ruth, could you please help me get an equal number of samples for each category?
Thanks, this is helpful. Do you know how to calculate the random sample size based on the row count? I have to do this for audit purposes on about 20 tables, and I'm currently using an online calculator. I would really like to automate it all in Power BI.
Never done it, have you tried asking in the power bi community?
/Ruth
@@CurbalEN not yet, but I will :)