Natural Order

Returns a list of elements sorted in their 'natural' order as designed in the data model.

Syntax & Usage

Order([List], NATURAL)
  • Connect the "Natural Order" block to the list you want to sort; there is no need to configure the Natural Order block from the Properties panel.

Example

Here to Product hierarchy is sorted by natural order:

{Order({AllMembers([products].[Product])},NATURAL)}

When added to the query, the set's members are listed in their natural order, as designed in the data model: