Forum Discussion
Solved
Add a new column for a random sample
Hi, I'm looking to randomly select 50% of rows in a table based on a filter, creating a new column that adds "Sampled" to the row being sampled" I've tried the following code but it doesn't w...
I'm not sure if I understood you correctly, but try this anyway
you forgot the ) after ASC
VAR _SampleSize = SELECTCOLUMNS( SAMPLE(_randomlyselect,_tbl,[Asset Code],ASC),"@Asset Code",[Asset Code],"@High Value Asset 2",[High Value Asset 2])