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.