Forum Discussion

orourkebp's avatar
orourkebp
Frequent Visitor
9 years ago
Solved

Selecting Random set of Records from a Dataset

Hello all,    New Power BI user.   Tried some examples found on the web but I cannot seem to apply them to this scenario.   I have a dataset of purchases for various branches around the United ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    orourkebp,

     

    RAND function return a random value for each row. Please refer the screenshot below.

     

    Regards,

    Charlie Liao

orourkebp's avatar
orourkebp
Frequent Visitor
9 years ago

Thank you smoupre.

 

These have promise.  But I need to assign a random value to each record first.  I think I need to create a new column and assign a random value to each record.  Tried using Number.Random but it provides the same value to each row.  Once, I have the values assigned your suggestion will be a good next step so I appreciate that.  I may have to go the DAX route.

 

Appreciate your help.

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

orourkebp,

 

RAND function return a random value for each row. Please refer the screenshot below.

 

Regards,

Charlie Liao

  • orourkebp's avatar
    orourkebp
    Frequent Visitor
    9 years ago

    Thank you, Charlie.

     

    I was actually looking for a solution to part of the query step which is probably not the correct way of thinking.  

     

    I appreciate your feedback.

     

    Brian