DAX Information - ISONORAFTER function

Description

Takes a variable number of triples, the first two values in a triple are the expressions to be compared, and the third parameter indicates the sort order. The sort order can be ascending (default) or descending.

The first parameter in a triple is compared with the second parameter, based on the sort order. If the sort order is ascending, the comparison to be done is, the first parameter greater than or equal to the second parameter. If the sort order is descending, the comparison to be done is, the second parameter less than or equal to the first parameter.

ISONORAFTER function returns TRUE if any of the comparisons is TRUE, otherwise returns FALSE.

DAX ISONORAFTER function is new in Excel 2016.

Syntax

ISONORAFTER (
   <scalar_expression>, <scalar_expression>, [sort_order],  
   [<scalar_expression>, <scalar_expression>, [sort_order]] …
)

Parameters

Sr.No. Parameter & Description
1

scalar_expression

Any expression that returns a scalar value like a column reference or integer or string value.

Typically, the first parameter is a column reference and the second parameter is a scalar value.
2

sort_order

Optional.

The order in which the comparison is done.

ASC: Ascending, or

DEC: Descending.

If omitted, default is ascending.

Return Value

TRUE or FALSE.

Example

= ISONORAFTER(2,0,DESC,2,1,DESC): 
   This DAX formula returns FALSE, because both 0 and 1 are not greater than 2.
= ISONORAFTER(2,5,DESC,2,1,DESC): 
   This DAX formula returns TRUE, because 5 is greater than 2.
dax_functions_information.htm
Advertisements