Home » DAX » SAMPLE DAX Function


Sample DAX output

SAMPLE DAX function is used to returns a sample of N rows from the specified table. This function comes under Statistical functions category.


SAMPLE(<n_value>, <table>, <orderBy_expression>, <order>, <orderBy_expression>, <order>…)

Let’s get started-

Go to the Modeling tab> Click on New table

Create table using DAX

Create table using DAX

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.

Sample DAX output

Sample DAX output

Refer DAX post:- DAX Tutorials

Leave a Reply