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