Use Power Query to Extract Random Data Samples

Поделиться
HTML-код
  • Опубликовано: 23 авг 2024
  • #powerquery #excel #microsoftexcel #msoffice #office365 #data #dataanalytics #dataanalysis #microsoft365

Комментарии • 4

  • @MarshaMinus100
    @MarshaMinus100 2 месяца назад +1

    Great tutorial. This solves the exact problem I was working on. 🥳

  • @KervinReader
    @KervinReader 3 месяца назад

    This is really good. But I'd like to ask, do we need to do the same procedure again and again if I have another data set? Or can I just copy and paste my new set of data directly.

  • @gan2801
    @gan2801 Год назад

    Hi Thank you for the details, however am having issues with the method that you mentioned.
    1. Random.between is not working and giving me same number as random, however if i use random.number then it works. But the main issue here is after close&load I get a sample with 5 for each user.
    But when I refresh the table, only the random number is being refreshed but not the respective details for the users.
    Like only "Index.random" is being changed rest all other fields are constant. Can you help me here please, need this for a project am working on

  • @subjectb
    @subjectb Год назад

    I tried this, but I keep getting Expression.Error: The key didn't match any rows in the table