SAMPLE DAX function is used to returns a sample of N rows from the specified table. This function comes under Statistical functions category.
Syntax
SAMPLE(<n_value>, <table>, <orderBy_expression>, <order>, <orderBy_expression>, <order>…)
Let’s get started-
Go to the Modeling tab> Click on New table
Now write below DAX to fetch N number of rows sample data from the specified table.
Sample Table = SAMPLE(100, Orders, Orders[Order Date], ASC)
As you can see the below given screen shot, new table is created with specific number of rows & order.
Refer DAX post:-Â DAX Tutorials
