Visit my website: aaapower.net

Content:
0:00 intro
0:42 Example data
1:40 Create a list of random numbers (List.Transform/Number.RandomBetween)
7:15 Collect the sample from the original table (Table.FromRecords)
9:13 Convert the query into a Custom Function
10:50 Invoke the custom function to select a random sample from any table
13:07 Close

To watch PQB: Power Query Basics Series:
   • PQB :Power Query Basics  

To watch PT: Pivot Tables Series:
   • Excel Data Analysis: PT  Pivot Tables  

To download the working files:
https://drive.google.com/drive/folder...

To subscribe:
   / @aaaexcelenglish  

To follow on Facebook:
  / excelispower  

To follow on LinkedIn:
  / amratef