Forum Discussion
First N rows
Hi Anonymous,
You can write something like either of these expressions (assuming your original table is called Clients):
Client Sample = SAMPLE ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] ) Client Sample = TOPN ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] )
Both of these add a column [rand] to the resulting table, which could be removed with SELECTCOLUMNS if needed.
Regards,
Owen
Hello everyone!
I am trying to filter the FIRST N rows of a table dynamically (NOT TOP N, FIRST N ROWS!). For instance; lets say I have a table with 20 records. I would like to reach the first 5 rows without doing any ranking, sorting or any other process, just want to get first 5 rows whatever information are in those rows. I also need a slicer to select the N dynamically, so would be awesome if you could help me out about this.
Cheers!
Solved! Thanks for your consideration.
Cheers!What was the solve? was it the solution noted above? Thank you.
