ISONORAFTER

ISONORAFTER is a DAX function that returns TRUE for a row that meets all specified conditions, emulating the behavior of the Start At clause.

Syntax

ISONORAFTER(
   [ Value1, ... ],
   [ Value2, ... ],
   [ Order, ... ]
)

Argument	Properties	Description
Value1	Repeatable	Expression to be compared with second parameter.
Value2	Repeatable	Expression to be compared with first parameter.
Order	Optional, Repeatable	The order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending.

Return Values

True or false.

Remarks

This function is similar to ISAFTER. The difference is ISONORAFTER returns true for values sorted on or after the filter values, where ISAFTER returns true for values sorted strictly after the filter values.

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

For the following table named, Info:

Country/Region	State	Count	Total
IND	JK	20	800
IND	MH	25	1000
IND	WB	10	900
USA	CA	5	500
USA	WA	10	900

The following expression:

FILTER (
    Info,
    ISONORAFTER (
        Info[Country], "IND", ASC,
        Info[State], "MH", ASC )
)

Returns:

Country/Region	State	Count	Total
IND	MH	25	1000
IND	WB	10	900
USA	CA	5	500
USA	WA	10	900

Related functions

Other functions related to ISONORAFTER are:

• ISAFTER

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/isonorafter-function-dax